DataClean

Dataset statistics

Number of variables	41
Number of observations	230436
Missing cells	1593261
Missing cells (%)	16.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	41.1 MiB
Average record size in memory	187.2 B

Variable types

Numeric	16
DateTime	5
Categorical	20

Alerts

`S_sprache` has constant value "Deutsch"	Constant
`Kommentar` has a high cardinality: 60552 distinct values	High cardinality
`ft_tu` has a high cardinality: 55 distinct values	High cardinality
`ft_vm` has a high cardinality: 18455 distinct values	High cardinality
`fg_startort` has a high cardinality: 12200 distinct values	High cardinality
`fg_zielort` has a high cardinality: 12048 distinct values	High cardinality
`ft_startort` has a high cardinality: 6271 distinct values	High cardinality
`ft_zielort` has a high cardinality: 5373 distinct values	High cardinality
`participant_id` is highly correlated with `device_type`	High correlation
`wime_personal` is highly correlated with `wime_komfort` and 7 other fields	High correlation
`wime_komfort` is highly correlated with `wime_personal` and 7 other fields	High correlation
`wime_sauberkeit` is highly correlated with `wime_personal` and 6 other fields	High correlation
`wime_puenktlich` is highly correlated with `wime_personal` and 6 other fields	High correlation
`wime_platzangebot` is highly correlated with `wime_personal` and 6 other fields	High correlation
`wime_gesamtzuf` is highly correlated with `wime_personal` and 7 other fields	High correlation
`wime_preis_leistung` is highly correlated with `wime_personal` and 5 other fields	High correlation
`wime_fahrplan` is highly correlated with `wime_personal` and 6 other fields	High correlation
`wime_oes_fahrt` is highly correlated with `wime_personal` and 3 other fields	High correlation
`S_alter` is highly correlated with `S_sprache`	High correlation
`u_preis` is highly correlated with `S_sprache`	High correlation
`ft_startort_uic` is highly correlated with `ft_tu` and 2 other fields	High correlation
`ft_zielort_uic` is highly correlated with `ft_tu` and 2 other fields	High correlation
`fg_startort_uic` is highly correlated with `ft_startort_uic` and 1 other fields	High correlation
`fg_zielort_uic` is highly correlated with `ft_tu` and 2 other fields	High correlation
`S_sprache` is highly correlated with `S_AB3_HTA` and 12 other fields	High correlation
`S_sex` is highly correlated with `S_sprache`	High correlation
`S_wohnsitz` is highly correlated with `S_sprache`	High correlation
`u_klassencode` is highly correlated with `S_sprache`	High correlation
`S_AB3_HTA` is highly correlated with `u_fahrausweis`	High correlation
`R_anschluss` is highly correlated with `wime_puenktlich` and 1 other fields	High correlation
`R_stoerung` is highly correlated with `wime_puenktlich` and 1 other fields	High correlation
`device_type` is highly correlated with `participant_id`	High correlation
`dispcode` is highly correlated with `S_sprache`	High correlation
`u_ticket` is highly correlated with `S_sprache`	High correlation
`u_fahrausweis` is highly correlated with `S_AB3_HTA`	High correlation
`R_zweck` is highly correlated with `S_sprache`	High correlation
`ft_tu` is highly correlated with `ft_startort_uic` and 4 other fields	High correlation
`ft_vm_kurz` is highly correlated with `ft_startort_uic` and 3 other fields	High correlation
`Kommentar` has 168258 (73.0%) missing values	Missing
`wime_personal` has 151269 (65.6%) missing values	Missing
`wime_komfort` has 50871 (22.1%) missing values	Missing
`wime_sauberkeit` has 47991 (20.8%) missing values	Missing
`wime_puenktlich` has 47365 (20.6%) missing values	Missing
`wime_platzangebot` has 46570 (20.2%) missing values	Missing
`wime_gesamtzuf` has 39319 (17.1%) missing values	Missing
`wime_preis_leistung` has 15523 (6.7%) missing values	Missing
`wime_fahrplan` has 8358 (3.6%) missing values	Missing
`wime_oes_fahrt` has 55345 (24.0%) missing values	Missing
`S_alter` has 5860 (2.5%) missing values	Missing
`S_sex` has 5562 (2.4%) missing values	Missing
`S_wohnsitz` has 5561 (2.4%) missing values	Missing
`u_klassencode` has 6082 (2.6%) missing values	Missing
`S_AB3_HTA` has 12328 (5.3%) missing values	Missing
`R_anschluss` has 102538 (44.5%) missing values	Missing
`R_stoerung` has 48374 (21.0%) missing values	Missing
`device_type` has 82382 (35.8%) missing values	Missing
`dispcode` has 82382 (35.8%) missing values	Missing
`u_ticket` has 40694 (17.7%) missing values	Missing
`u_fahrausweis` has 110636 (48.0%) missing values	Missing
`u_preis` has 22060 (9.6%) missing values	Missing
`R_zweck` has 5509 (2.4%) missing values	Missing
`ft_abfahrt` has 38826 (16.8%) missing values	Missing
`ft_ankunft` has 38826 (16.8%) missing values	Missing
`ft_startort_uic` has 38826 (16.8%) missing values	Missing
`ft_tu` has 38826 (16.8%) missing values	Missing
`ft_vm` has 38826 (16.8%) missing values	Missing
`ft_vm_kurz` has 38826 (16.8%) missing values	Missing
`ft_zielort_uic` has 38826 (16.8%) missing values	Missing
`fg_abfahrt` has 27962 (12.1%) missing values	Missing
`fg_ankunft` has 27962 (12.1%) missing values	Missing
`fg_startort_uic` has 27962 (12.1%) missing values	Missing
`fg_zielort_uic` has 27962 (12.1%) missing values	Missing
`fg_startort` has 6747 (2.9%) missing values	Missing
`fg_zielort` has 6744 (2.9%) missing values	Missing
`ft_startort` has 17653 (7.7%) missing values	Missing
`ft_zielort` has 17650 (7.7%) missing values	Missing
`u_preis` is highly skewed (γ1 = 20.00160275)	Skewed
`ft_startort_uic` is highly skewed (γ1 = -38.67778891)	Skewed
`fg_startort_uic` is highly skewed (γ1 = -54.04320342)	Skewed
`fg_zielort_uic` is highly skewed (γ1 = -45.87708909)	Skewed
`Kommentar` is uniformly distributed	Uniform
`participant_id` has unique values	Unique
`wime_komfort` has 2958 (1.3%) zeros	Zeros
`wime_puenktlich` has 4706 (2.0%) zeros	Zeros
`wime_platzangebot` has 6408 (2.8%) zeros	Zeros
`wime_preis_leistung` has 6484 (2.8%) zeros	Zeros
`wime_fahrplan` has 5359 (2.3%) zeros	Zeros

Reproduction

Analysis started	2022-11-25 11:54:17.320043
Analysis finished	2022-11-25 12:18:49.550860
Duration	24 minutes and 32.23 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

participant_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	230436
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	375292.0741

Minimum	642
Maximum	589965
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	642
5-th percentile	66072.5
Q1	339252.75
median	428705.5
Q3	508468.25
95-th percentile	574189.25
Maximum	589965
Range	589323
Interquartile range (IQR)	169215.5

Descriptive statistics

Standard deviation	172347.8836
Coefficient of variation (CV)	0.4592366734
Kurtosis	-0.7924523896
Mean	375292.0741
Median Absolute Deviation (MAD)	84682.5
Skewness	-0.7931829375
Sum	8.648080438 × 10¹⁰
Variance	2.9703793 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
642	1	< 0.1%
481185	1	< 0.1%
481228	1	< 0.1%
481229	1	< 0.1%
481230	1	< 0.1%
481231	1	< 0.1%
481232	1	< 0.1%
481234	1	< 0.1%
481235	1	< 0.1%
481236	1	< 0.1%
Other values (230426)	230426	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
642	1	< 0.1%
657	1	< 0.1%
24756	1	< 0.1%
25620	1	< 0.1%
41215	1	< 0.1%
41305	1	< 0.1%
41334	1	< 0.1%
41376	1	< 0.1%
41423	1	< 0.1%
41459	1	< 0.1%

Value	Count	Frequency (%)
589965	1	< 0.1%
589962	1	< 0.1%
589959	1	< 0.1%
589957	1	< 0.1%
589956	1	< 0.1%
589955	1	< 0.1%
589954	1	< 0.1%
589951	1	< 0.1%
589946	1	< 0.1%
589945	1	< 0.1%

u_date
Date

Distinct	1330
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Minimum	2019-01-01 00:00:00
Maximum	2022-11-16 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Kommentar
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	60552
Distinct (%)	97.4%
Missing	168258
Missing (%)	73.0%
Memory size	1.8 MiB

Nein	148
-	98
	81
Keine	78
nein	68
Other values (60547)	61705

Length

Max length	2058
Median length	1360
Mean length	173.7346167
Min length	0

Characters and Unicode

Total characters	10802471
Distinct characters	146
Distinct categories	16 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	60158 ?
Unique (%)	96.8%

Sample

1st row	Habe schon mehrmals erlebt, dass es im Speisewagen keine Gipfeli gab am Morgen. Das war jeweils ärgerlich.
2nd row	Ansteben, dass auch in gut frequentierte periphere Zentren eine Fahrplanverdichtung erfolgt.Die Trennung von Fernverkehr und Regionalverkehr ist in Frage zu stellen. Schade, dass ich zu meiner ersten Fahrt am Tag Stellung nehmen muss, beginne ich dich mein Reiseprogramm aus Platzgründen im Zug bewusst früher als es nötig wäre...
3rd row	Die 1. Klasse muss deutluch aufgewertet werden. Die neuen untergeordneten Haltestellen wie Zürich Altstetten und Zürich Oerlikon trüben Fahrerlebnis massiv.
4th row	Bessere (neue!) Züge in der Westschweiz!!! Längere Züge zwischen Bern und Genève (vor allem zwischen 16 Uhr und 19 Uhr) (mindestens +3 Wagen). Mehr 1. Klasse Gutscheine für 2.Klass-GA-Inhaber.
5th row	- mehr Monitore - die Monitore so platzieren, dass man sie nicht suchen muss, wenn man knapp zum Bahnhof kommt, vor allem jetzt, wo alle Züge ständig auf anderen Gleisen fahren und die Wege sowieso

Common Values

Value	Count	Frequency (%)
Nein	148	0.1%
-	98	< 0.1%
	81	< 0.1%
Keine	78	< 0.1%
nein	68	< 0.1%
Mehr Sitzplätze	40	< 0.1%
Pünktlichkeit	36	< 0.1%
.	35	< 0.1%
keine	33	< 0.1%
Preise senken	32	< 0.1%
Other values (60542)	61529	26.7%
(Missing)	168258	73.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
die	43612	2.6%
der	36315	2.2%
ich	35132	2.1%
und	34800	2.1%
in	26761	1.6%
nicht	24846	1.5%
ist	20547	1.2%
es	20325	1.2%
das	18663	1.1%
zu	18527	1.1%
Other values (71786)	1389423	83.3%

Most occurring characters

Value	Count	Frequency (%)
	1649434	15.3%
e	1327903	12.3%
n	847509	7.8%
i	658245	6.1%
r	579122	5.4%
s	525320	4.9%
t	516616	4.8%
a	484606	4.5%
h	413879	3.8%
d	324527	3.0%
Other values (136)	3475310	32.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8206781	76.0%
Space Separator	1649458	15.3%
Uppercase Letter	585779	5.4%
Other Punctuation	249385	2.3%
Decimal Number	59957	0.6%
Dash Punctuation	24143	0.2%
Open Punctuation	12244	0.1%
Close Punctuation	12118	0.1%
Math Symbol	1384	< 0.1%
Initial Punctuation	924	< 0.1%
Other values (6)	298	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1327903	16.2%
n	847509	10.3%
i	658245	8.0%
r	579122	7.1%
s	525320	6.4%
t	516616	6.3%
a	484606	5.9%
h	413879	5.0%
d	324527	4.0%
u	322966	3.9%
Other values (40)	2206088	26.9%

Uppercase Letter

Value	Count	Frequency (%)
B	63969	10.9%
S	60102	10.3%
Z	47613	8.1%
A	45854	7.8%
D	36245	6.2%
W	26608	4.5%
M	26608	4.5%
I	25603	4.4%
P	25343	4.3%
F	24028	4.1%
Other values (24)	203806	34.8%

Other Punctuation

Value	Count	Frequency (%)
.	137322	55.1%
,	69948	28.0%
!	20445	8.2%
?	6965	2.8%
:	6735	2.7%
/	4404	1.8%
;	1112	0.4%
'	938	0.4%
…	593	0.2%
&	368	0.1%
Other values (6)	555	0.2%

Decimal Number

Value	Count	Frequency (%)
1	14409	24.0%
2	11834	19.7%
0	10771	18.0%
3	5443	9.1%
5	4437	7.4%
4	3605	6.0%
7	2584	4.3%
6	2477	4.1%
9	2201	3.7%
8	2196	3.7%

Math Symbol

Value	Count	Frequency (%)
>	632	45.7%
+	271	19.6%
=	256	18.5%
<	207	15.0%
×	8	0.6%
~	7	0.5%
\|	3	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	11528	94.2%
„	641	5.2%
‚	67	0.5%
[	7	0.1%
{	1	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
`	36	63.2%
¨	11	19.3%
´	6	10.5%
^	4	7.0%

Dash Punctuation

Value	Count	Frequency (%)
-	23941	99.2%
–	108	0.4%
—	94	0.4%

Close Punctuation

Value	Count	Frequency (%)
)	12106	99.9%
]	8	0.1%
}	4	< 0.1%

Initial Punctuation

Value	Count	Frequency (%)
“	639	69.2%
‘	233	25.2%
«	52	5.6%

Final Punctuation

Value	Count	Frequency (%)
’	48	36.4%
»	48	36.4%
”	36	27.3%

Space Separator

Value	Count	Frequency (%)
	1649434	> 99.9%
	24	< 0.1%

Currency Symbol

Value	Count	Frequency (%)
€	10	90.9%
$	1	9.1%

Other Number

Value	Count	Frequency (%)
½	7	87.5%
¼	1	12.5%

Other Symbol

Value	Count	Frequency (%)
°	54	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	36	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8792560	81.4%
Common	2009911	18.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1327903	15.1%
n	847509	9.6%
i	658245	7.5%
r	579122	6.6%
s	525320	6.0%
t	516616	5.9%
a	484606	5.5%
h	413879	4.7%
d	324527	3.7%
u	322966	3.7%
Other values (74)	2791867	31.8%

Common

Value	Count	Frequency (%)
	1649434	82.1%
.	137322	6.8%
,	69948	3.5%
-	23941	1.2%
!	20445	1.0%
1	14409	0.7%
)	12106	0.6%
2	11834	0.6%
(	11528	0.6%
0	10771	0.5%
Other values (52)	48173	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10633036	98.4%
None	166959	1.5%
Punctuation	2466	< 0.1%
Currency Symbols	10	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1649434	15.5%
e	1327903	12.5%
n	847509	8.0%
i	658245	6.2%
r	579122	5.4%
s	525320	4.9%
t	516616	4.9%
a	484606	4.6%
h	413879	3.9%
d	324527	3.1%
Other values (83)	3305875	31.1%

None

Value	Count	Frequency (%)
ü	80947	48.5%
ä	55722	33.4%
ö	26423	15.8%
Ö	1290	0.8%
Ü	824	0.5%
ß	646	0.4%
Ä	484	0.3%
é	172	0.1%
è	57	< 0.1%
°	54	< 0.1%
Other values (32)	340	0.2%

Punctuation

Value	Count	Frequency (%)
„	641	26.0%
“	639	25.9%
…	593	24.0%
‘	233	9.4%
–	108	4.4%
—	94	3.8%
‚	67	2.7%
’	48	1.9%
”	36	1.5%
•	7	0.3%

Currency Symbols

Value	Count	Frequency (%)
€	10	100.0%

wime_personal
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	13
Distinct (%)	< 0.1%
Missing	151269
Missing (%)	65.6%
Infinite	0
Infinite (%)	0.0%
Mean	89.89734078

Minimum	0
Maximum	100
Zeros	701
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	77.77777778
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	22.22222222

Descriptive statistics

Standard deviation	17.81349174
Coefficient of variation (CV)	0.1981537116
Kurtosis	6.733489346
Mean	89.89734078
Median Absolute Deviation (MAD)	0
Skewness	-2.362104001
Sum	7116902.778
Variance	317.320488
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	52039	22.6%
75	9762	4.2%
88.88888889	5378	2.3%
77.77777778	4851	2.1%
66.66666667	1880	0.8%
50	1777	0.8%
44.44444444	886	0.4%
55.55555556	817	0.4%
0	701	0.3%
25	445	0.2%
Other values (3)	631	0.3%
(Missing)	151269	65.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	701	0.3%
11.11111111	138	0.1%
22.22222222	228	0.1%
25	445	0.2%
33.33333333	265	0.1%
44.44444444	886	0.4%
50	1777	0.8%
55.55555556	817	0.4%
66.66666667	1880	0.8%
75	9762	4.2%

Value	Count	Frequency (%)
100	52039	22.6%
88.88888889	5378	2.3%
77.77777778	4851	2.1%
75	9762	4.2%
66.66666667	1880	0.8%
55.55555556	817	0.4%
50	1777	0.8%
44.44444444	886	0.4%
33.33333333	265	0.1%
25	445	0.2%

wime_komfort
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	13
Distinct (%)	< 0.1%
Missing	50871
Missing (%)	22.1%
Infinite	0
Infinite (%)	0.0%
Mean	78.94156248

Minimum	0
Maximum	100
Zeros	2958
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	33.33333333
Q1	75
median	77.77777778
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	22.80893395
Coefficient of variation (CV)	0.2889344121
Kurtosis	1.479833592
Mean	78.94156248
Median Absolute Deviation (MAD)	22.22222222
Skewness	-1.241166618
Sum	14175141.67
Variance	520.2474678
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	68640	29.8%
75	37779	16.4%
77.77777778	17476	7.6%
88.88888889	12656	5.5%
66.66666667	10829	4.7%
50	10475	4.5%
55.55555556	6008	2.6%
44.44444444	4853	2.1%
0	2958	1.3%
25	2840	1.2%
Other values (3)	5051	2.2%
(Missing)	50871	22.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2958	1.3%
11.11111111	1003	0.4%
22.22222222	1686	0.7%
25	2840	1.2%
33.33333333	2362	1.0%
44.44444444	4853	2.1%
50	10475	4.5%
55.55555556	6008	2.6%
66.66666667	10829	4.7%
75	37779	16.4%

Value	Count	Frequency (%)
100	68640	29.8%
88.88888889	12656	5.5%
77.77777778	17476	7.6%
75	37779	16.4%
66.66666667	10829	4.7%
55.55555556	6008	2.6%
50	10475	4.5%
44.44444444	4853	2.1%
33.33333333	2362	1.0%
25	2840	1.2%

wime_sauberkeit
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	13
Distinct (%)	< 0.1%
Missing	47991
Missing (%)	20.8%
Infinite	0
Infinite (%)	0.0%
Mean	79.26533415

Minimum	0
Maximum	100
Zeros	1628
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	44.44444444
Q1	75
median	77.77777778
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	21.46045723
Coefficient of variation (CV)	0.2707420268
Kurtosis	1.140701001
Mean	79.26533415
Median Absolute Deviation (MAD)	22.22222222
Skewness	-1.100859622
Sum	14461563.89
Variance	460.5512243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	67360	29.2%
75	40500	17.6%
77.77777778	18048	7.8%
88.88888889	13669	5.9%
50	12953	5.6%
66.66666667	10791	4.7%
55.55555556	5597	2.4%
44.44444444	4517	2.0%
25	3281	1.4%
33.33333333	2172	0.9%
Other values (3)	3557	1.5%
(Missing)	47991	20.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1628	0.7%
11.11111111	606	0.3%
22.22222222	1323	0.6%
25	3281	1.4%
33.33333333	2172	0.9%
44.44444444	4517	2.0%
50	12953	5.6%
55.55555556	5597	2.4%
66.66666667	10791	4.7%
75	40500	17.6%

Value	Count	Frequency (%)
100	67360	29.2%
88.88888889	13669	5.9%
77.77777778	18048	7.8%
75	40500	17.6%
66.66666667	10791	4.7%
55.55555556	5597	2.4%
50	12953	5.6%
44.44444444	4517	2.0%
33.33333333	2172	0.9%
25	3281	1.4%

wime_puenktlich
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	13
Distinct (%)	< 0.1%
Missing	47365
Missing (%)	20.6%
Infinite	0
Infinite (%)	0.0%
Mean	88.88567216

Minimum	0
Maximum	100
Zeros	4706
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	33.33333333
Q1	88.88888889
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	11.11111111

Descriptive statistics

Standard deviation	22.15786224
Coefficient of variation (CV)	0.2492849713
Kurtosis	6.132215583
Mean	88.88567216
Median Absolute Deviation (MAD)	0
Skewness	-2.504766294
Sum	16272388.89
Variance	490.9708589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	126462	54.9%
75	17816	7.7%
88.88888889	11720	5.1%
77.77777778	7334	3.2%
0	4706	2.0%
50	4238	1.8%
66.66666667	2961	1.3%
25	2168	0.9%
44.44444444	1568	0.7%
55.55555556	1485	0.6%
Other values (3)	2613	1.1%
(Missing)	47365	20.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4706	2.0%
11.11111111	630	0.3%
22.22222222	990	0.4%
25	2168	0.9%
33.33333333	993	0.4%
44.44444444	1568	0.7%
50	4238	1.8%
55.55555556	1485	0.6%
66.66666667	2961	1.3%
75	17816	7.7%

Value	Count	Frequency (%)
100	126462	54.9%
88.88888889	11720	5.1%
77.77777778	7334	3.2%
75	17816	7.7%
66.66666667	2961	1.3%
55.55555556	1485	0.6%
50	4238	1.8%
44.44444444	1568	0.7%
33.33333333	993	0.4%
25	2168	0.9%

wime_platzangebot
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	13
Distinct (%)	< 0.1%
Missing	46570
Missing (%)	20.2%
Infinite	0
Infinite (%)	0.0%
Mean	80.19040436

Minimum	0
Maximum	100
Zeros	6408
Zeros (%)	2.8%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	22.22222222
Q1	75
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	26.76994683
Coefficient of variation (CV)	0.3338298023
Kurtosis	1.366630743
Mean	80.19040436
Median Absolute Deviation (MAD)	0
Skewness	-1.448636276
Sum	14744288.89
Variance	716.6300534
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	92774	40.3%
75	26389	11.5%
77.77777778	12108	5.3%
88.88888889	10362	4.5%
50	9925	4.3%
66.66666667	6883	3.0%
0	6408	2.8%
25	4651	2.0%
55.55555556	4103	1.8%
44.44444444	3944	1.7%
Other values (3)	6319	2.7%
(Missing)	46570	20.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6408	2.8%
11.11111111	1554	0.7%
22.22222222	2323	1.0%
25	4651	2.0%
33.33333333	2442	1.1%
44.44444444	3944	1.7%
50	9925	4.3%
55.55555556	4103	1.8%
66.66666667	6883	3.0%
75	26389	11.5%

Value	Count	Frequency (%)
100	92774	40.3%
88.88888889	10362	4.5%
77.77777778	12108	5.3%
75	26389	11.5%
66.66666667	6883	3.0%
55.55555556	4103	1.8%
50	9925	4.3%
44.44444444	3944	1.7%
33.33333333	2442	1.1%
25	4651	2.0%

wime_gesamtzuf
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	13
Distinct (%)	< 0.1%
Missing	39319
Missing (%)	17.1%
Infinite	0
Infinite (%)	0.0%
Mean	84.57496659

Minimum	0
Maximum	100
Zeros	2071
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	75
median	88.88888889
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	19.58447459
Coefficient of variation (CV)	0.2315634919
Kurtosis	3.735611901
Mean	84.57496659
Median Absolute Deviation (MAD)	11.11111111
Skewness	-1.722032645
Sum	16163713.89
Variance	383.5516449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	89357	38.8%
75	39018	16.9%
88.88888889	20408	8.9%
77.77777778	16835	7.3%
50	7273	3.2%
66.66666667	6781	2.9%
55.55555556	2808	1.2%
44.44444444	2200	1.0%
0	2071	0.9%
25	1925	0.8%
Other values (3)	2441	1.1%
(Missing)	39319	17.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2071	0.9%
11.11111111	476	0.2%
22.22222222	916	0.4%
25	1925	0.8%
33.33333333	1049	0.5%
44.44444444	2200	1.0%
50	7273	3.2%
55.55555556	2808	1.2%
66.66666667	6781	2.9%
75	39018	16.9%

Value	Count	Frequency (%)
100	89357	38.8%
88.88888889	20408	8.9%
77.77777778	16835	7.3%
75	39018	16.9%
66.66666667	6781	2.9%
55.55555556	2808	1.2%
50	7273	3.2%
44.44444444	2200	1.0%
33.33333333	1049	0.5%
25	1925	0.8%

wime_preis_leistung
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	13
Distinct (%)	< 0.1%
Missing	15523
Missing (%)	6.7%
Infinite	0
Infinite (%)	0.0%
Mean	73.86437251

Minimum	0
Maximum	100
Zeros	6484
Zeros (%)	2.8%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	25
Q1	50
median	75
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	26.4163289
Coefficient of variation (CV)	0.3576328886
Kurtosis	0.2277005886
Mean	73.86437251
Median Absolute Deviation (MAD)	25
Skewness	-0.9184731838
Sum	15874413.89
Variance	697.8224327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	76703	33.3%
75	46435	20.2%
50	26008	11.3%
77.77777778	13319	5.8%
66.66666667	10095	4.4%
25	8592	3.7%
88.88888889	7822	3.4%
0	6484	2.8%
55.55555556	6301	2.7%
44.44444444	6265	2.7%
Other values (3)	6889	3.0%
(Missing)	15523	6.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6484	2.8%
11.11111111	1224	0.5%
22.22222222	2597	1.1%
25	8592	3.7%
33.33333333	3068	1.3%
44.44444444	6265	2.7%
50	26008	11.3%
55.55555556	6301	2.7%
66.66666667	10095	4.4%
75	46435	20.2%

Value	Count	Frequency (%)
100	76703	33.3%
88.88888889	7822	3.4%
77.77777778	13319	5.8%
75	46435	20.2%
66.66666667	10095	4.4%
55.55555556	6301	2.7%
50	26008	11.3%
44.44444444	6265	2.7%
33.33333333	3068	1.3%
25	8592	3.7%

wime_fahrplan
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	13
Distinct (%)	< 0.1%
Missing	8358
Missing (%)	3.6%
Infinite	0
Infinite (%)	0.0%
Mean	83.40204042

Minimum	0
Maximum	100
Zeros	5359
Zeros (%)	2.3%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	25
Q1	75
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	23.9071193
Coefficient of variation (CV)	0.2866490937
Kurtosis	2.541959888
Mean	83.40204042
Median Absolute Deviation (MAD)	0
Skewness	-1.688037225
Sum	18521758.33
Variance	571.5503531
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	120650	52.4%
75	33552	14.6%
77.77777778	14716	6.4%
88.88888889	12691	5.5%
50	10888	4.7%
66.66666667	7761	3.4%
0	5359	2.3%
25	4465	1.9%
55.55555556	3971	1.7%
44.44444444	3752	1.6%
Other values (3)	4273	1.9%
(Missing)	8358	3.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5359	2.3%
11.11111111	843	0.4%
22.22222222	1512	0.7%
25	4465	1.9%
33.33333333	1918	0.8%
44.44444444	3752	1.6%
50	10888	4.7%
55.55555556	3971	1.7%
66.66666667	7761	3.4%
75	33552	14.6%

Value	Count	Frequency (%)
100	120650	52.4%
88.88888889	12691	5.5%
77.77777778	14716	6.4%
75	33552	14.6%
66.66666667	7761	3.4%
55.55555556	3971	1.7%
50	10888	4.7%
44.44444444	3752	1.6%
33.33333333	1918	0.8%
25	4465	1.9%

wime_oes_fahrt
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	13
Distinct (%)	< 0.1%
Missing	55345
Missing (%)	24.0%
Infinite	0
Infinite (%)	0.0%
Mean	90.69958225

Minimum	0
Maximum	100
Zeros	410
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	66.66666667
Q1	77.77777778
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	22.22222222

Descriptive statistics

Standard deviation	14.73856196
Coefficient of variation (CV)	0.1624986753
Kurtosis	5.585256905
Mean	90.69958225
Median Absolute Deviation (MAD)	0
Skewness	-2.013682819
Sum	15880680.56
Variance	217.2252087
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
100	109793	47.6%
75	23797	10.3%
88.88888889	17023	7.4%
77.77777778	12838	5.6%
66.66666667	4233	1.8%
50	3336	1.4%
55.55555556	1487	0.6%
44.44444444	946	0.4%
25	594	0.3%
0	410	0.2%
Other values (3)	634	0.3%
(Missing)	55345	24.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	410	0.2%
11.11111111	106	< 0.1%
22.22222222	211	0.1%
25	594	0.3%
33.33333333	317	0.1%
44.44444444	946	0.4%
50	3336	1.4%
55.55555556	1487	0.6%
66.66666667	4233	1.8%
75	23797	10.3%

Value	Count	Frequency (%)
100	109793	47.6%
88.88888889	17023	7.4%
77.77777778	12838	5.6%
75	23797	10.3%
66.66666667	4233	1.8%
55.55555556	1487	0.6%
50	3336	1.4%
44.44444444	946	0.4%
33.33333333	317	0.1%
25	594	0.3%

S_sprache
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	225.3 KiB

Deutsch	230436

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	1613052
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Deutsch
2nd row	Deutsch
3rd row	Deutsch
4th row	Deutsch
5th row	Deutsch

Common Values

Value	Count	Frequency (%)
Deutsch	230436	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
deutsch	230436	100.0%

Most occurring characters

Value	Count	Frequency (%)
D	230436	14.3%
e	230436	14.3%
u	230436	14.3%
t	230436	14.3%
s	230436	14.3%
c	230436	14.3%
h	230436	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1382616	85.7%
Uppercase Letter	230436	14.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	230436	16.7%
u	230436	16.7%
t	230436	16.7%
s	230436	16.7%
c	230436	16.7%
h	230436	16.7%

Uppercase Letter

Value	Count	Frequency (%)
D	230436	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1613052	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	230436	14.3%
e	230436	14.3%
u	230436	14.3%
t	230436	14.3%
s	230436	14.3%
c	230436	14.3%
h	230436	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1613052	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	230436	14.3%
e	230436	14.3%
u	230436	14.3%
t	230436	14.3%
s	230436	14.3%
c	230436	14.3%
h	230436	14.3%

S_alter
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	89
Distinct (%)	< 0.1%
Missing	5860
Missing (%)	2.5%
Infinite	0
Infinite (%)	0.0%
Mean	51.63611873

Minimum	10
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	10
5-th percentile	23
Q1	40
median	53
Q3	64
95-th percentile	75
Maximum	98
Range	88
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	15.93706606
Coefficient of variation (CV)	0.3086418276
Kurtosis	-0.6199927104
Mean	51.63611873
Median Absolute Deviation (MAD)	12
Skewness	-0.3076231175
Sum	11596233
Variance	253.9900745
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
55	6334	2.7%
60	6155	2.7%
50	5969	2.6%
58	5521	2.4%
56	5513	2.4%
57	5504	2.4%
52	5439	2.4%
65	5402	2.3%
54	5245	2.3%
53	5205	2.3%
Other values (79)	168289	73.0%
(Missing)	5860	2.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	75	< 0.1%
11	42	< 0.1%
12	48	< 0.1%
13	69	< 0.1%
14	224	0.1%
15	562	0.2%
16	1205	0.5%
17	1498	0.7%
18	1639	0.7%
19	1431	0.6%

Value	Count	Frequency (%)
98	5	< 0.1%
97	2	< 0.1%
96	2	< 0.1%
95	9	< 0.1%
94	10	< 0.1%
93	7	< 0.1%
92	8	< 0.1%
91	26	< 0.1%
90	64	< 0.1%
89	54	< 0.1%

S_sex
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	5562
Missing (%)	2.4%
Memory size	225.3 KiB

weiblich	123941
männlich	100264
divers	669

Length

Max length	8
Median length	8
Mean length	7.994050001
Min length	6

Characters and Unicode

Total characters	1797654
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	männlich
2nd row	männlich
3rd row	weiblich
4th row	weiblich
5th row	weiblich

Common Values

Value	Count	Frequency (%)
weiblich	123941	53.8%
männlich	100264	43.5%
divers	669	0.3%
(Missing)	5562	2.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
weiblich	123941	55.1%
männlich	100264	44.6%
divers	669	0.3%

Most occurring characters

Value	Count	Frequency (%)
i	348815	19.4%
l	224205	12.5%
c	224205	12.5%
h	224205	12.5%
n	200528	11.2%
e	124610	6.9%
w	123941	6.9%
b	123941	6.9%
m	100264	5.6%
ä	100264	5.6%
Other values (4)	2676	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1797654	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	348815	19.4%
l	224205	12.5%
c	224205	12.5%
h	224205	12.5%
n	200528	11.2%
e	124610	6.9%
w	123941	6.9%
b	123941	6.9%
m	100264	5.6%
ä	100264	5.6%
Other values (4)	2676	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1797654	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	348815	19.4%
l	224205	12.5%
c	224205	12.5%
h	224205	12.5%
n	200528	11.2%
e	124610	6.9%
w	123941	6.9%
b	123941	6.9%
m	100264	5.6%
ä	100264	5.6%
Other values (4)	2676	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1697390	94.4%
None	100264	5.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	348815	20.6%
l	224205	13.2%
c	224205	13.2%
h	224205	13.2%
n	200528	11.8%
e	124610	7.3%
w	123941	7.3%
b	123941	7.3%
m	100264	5.9%
d	669	< 0.1%
Other values (3)	2007	0.1%

None

Value	Count	Frequency (%)
ä	100264	100.0%

S_wohnsitz
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	5561
Missing (%)	2.4%
Memory size	225.3 KiB

In der Schweiz / Liechtenstein	219516
In einem anderen Land	5359

Length

Max length	30
Median length	30
Mean length	29.78552084
Min length	21

Characters and Unicode

Total characters	6698019
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	In der Schweiz / Liechtenstein
2nd row	In der Schweiz / Liechtenstein
3rd row	In der Schweiz / Liechtenstein
4th row	In der Schweiz / Liechtenstein
5th row	In der Schweiz / Liechtenstein

Common Values

Value	Count	Frequency (%)
In der Schweiz / Liechtenstein	219516	95.3%
In einem anderen Land	5359	2.3%
(Missing)	5561	2.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
in	224875	20.1%
der	219516	19.6%
schweiz	219516	19.6%
	219516	19.6%
liechtenstein	219516	19.6%
einem	5359	0.5%
anderen	5359	0.5%
land	5359	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	1119016	16.7%
	894141	13.3%
n	685343	10.2%
i	663907	9.9%
c	439032	6.6%
h	439032	6.6%
t	439032	6.6%
d	230234	3.4%
I	224875	3.4%
L	224875	3.4%
Other values (8)	1338532	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4915096	73.4%
Space Separator	894141	13.3%
Uppercase Letter	669266	10.0%
Other Punctuation	219516	3.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1119016	22.8%
n	685343	13.9%
i	663907	13.5%
c	439032	8.9%
h	439032	8.9%
t	439032	8.9%
d	230234	4.7%
r	224875	4.6%
s	219516	4.5%
w	219516	4.5%
Other values (3)	235593	4.8%

Uppercase Letter

Value	Count	Frequency (%)
I	224875	33.6%
L	224875	33.6%
S	219516	32.8%

Space Separator

Value	Count	Frequency (%)
	894141	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	219516	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5584362	83.4%
Common	1113657	16.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1119016	20.0%
n	685343	12.3%
i	663907	11.9%
c	439032	7.9%
h	439032	7.9%
t	439032	7.9%
d	230234	4.1%
I	224875	4.0%
L	224875	4.0%
r	224875	4.0%
Other values (6)	894141	16.0%

Common

Value	Count	Frequency (%)
	894141	80.3%
/	219516	19.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6698019	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1119016	16.7%
	894141	13.3%
n	685343	10.2%
i	663907	9.9%
c	439032	6.6%
h	439032	6.6%
t	439032	6.6%
d	230234	3.4%
I	224875	3.4%
L	224875	3.4%
Other values (8)	1338532	20.0%

u_klassencode
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	6082
Missing (%)	2.6%
Memory size	225.3 KiB

2. Klasse	195783
1. Klasse	28571

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	2019186
Distinct characters	9
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2. Klasse
2nd row	1. Klasse
3rd row	2. Klasse
4th row	2. Klasse
5th row	2. Klasse

Common Values

Value	Count	Frequency (%)
2. Klasse	195783	85.0%
1. Klasse	28571	12.4%
(Missing)	6082	2.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
klasse	224354	50.0%
2	195783	43.6%
1	28571	6.4%

Most occurring characters

Value	Count	Frequency (%)
s	448708	22.2%
.	224354	11.1%
	224354	11.1%
K	224354	11.1%
l	224354	11.1%
a	224354	11.1%
e	224354	11.1%
2	195783	9.7%
1	28571	1.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1121770	55.6%
Other Punctuation	224354	11.1%
Space Separator	224354	11.1%
Uppercase Letter	224354	11.1%
Decimal Number	224354	11.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	448708	40.0%
l	224354	20.0%
a	224354	20.0%
e	224354	20.0%

Decimal Number

Value	Count	Frequency (%)
2	195783	87.3%
1	28571	12.7%

Other Punctuation

Value	Count	Frequency (%)
.	224354	100.0%

Space Separator

Value	Count	Frequency (%)
	224354	100.0%

Uppercase Letter

Value	Count	Frequency (%)
K	224354	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1346124	66.7%
Common	673062	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	448708	33.3%
K	224354	16.7%
l	224354	16.7%
a	224354	16.7%
e	224354	16.7%

Common

Value	Count	Frequency (%)
.	224354	33.3%
	224354	33.3%
2	195783	29.1%
1	28571	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2019186	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	448708	22.2%
.	224354	11.1%
	224354	11.1%
K	224354	11.1%
l	224354	11.1%
a	224354	11.1%
e	224354	11.1%
2	195783	9.7%
1	28571	1.4%

S_AB3_HTA
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	12328
Missing (%)	5.3%
Memory size	225.3 KiB

ja	180314
nein	37794

Length

Max length	4
Median length	2
Mean length	2.346562254
Min length	2

Characters and Unicode

Total characters	511804
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ja
2nd row	ja
3rd row	ja
4th row	ja
5th row	ja

Common Values

Value	Count	Frequency (%)
ja	180314	78.2%
nein	37794	16.4%
(Missing)	12328	5.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
ja	180314	82.7%
nein	37794	17.3%

Most occurring characters

Value	Count	Frequency (%)
j	180314	35.2%
a	180314	35.2%
n	75588	14.8%
e	37794	7.4%
i	37794	7.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	511804	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
j	180314	35.2%
a	180314	35.2%
n	75588	14.8%
e	37794	7.4%
i	37794	7.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	511804	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
j	180314	35.2%
a	180314	35.2%
n	75588	14.8%
e	37794	7.4%
i	37794	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	511804	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
j	180314	35.2%
a	180314	35.2%
n	75588	14.8%
e	37794	7.4%
i	37794	7.4%

R_anschluss
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	102538
Missing (%)	44.5%
Memory size	225.3 KiB

Ja	121855
Nein	6043

Length

Max length	4
Median length	2
Mean length	2.094497177
Min length	2

Characters and Unicode

Total characters	267882
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ja
2nd row	Ja
3rd row	Ja
4th row	Ja
5th row	Ja

Common Values

Value	Count	Frequency (%)
Ja	121855	52.9%
Nein	6043	2.6%
(Missing)	102538	44.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
ja	121855	95.3%
nein	6043	4.7%

Most occurring characters

Value	Count	Frequency (%)
J	121855	45.5%
a	121855	45.5%
N	6043	2.3%
e	6043	2.3%
i	6043	2.3%
n	6043	2.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	139984	52.3%
Uppercase Letter	127898	47.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	121855	87.0%
e	6043	4.3%
i	6043	4.3%
n	6043	4.3%

Uppercase Letter

Value	Count	Frequency (%)
J	121855	95.3%
N	6043	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	267882	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
J	121855	45.5%
a	121855	45.5%
N	6043	2.3%
e	6043	2.3%
i	6043	2.3%
n	6043	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	267882	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
J	121855	45.5%
a	121855	45.5%
N	6043	2.3%
e	6043	2.3%
i	6043	2.3%
n	6043	2.3%

R_stoerung
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	48374
Missing (%)	21.0%
Memory size	225.3 KiB

Nein	167975
Ja	14087

Length

Max length	4
Median length	4
Mean length	3.845250519
Min length	2

Characters and Unicode

Total characters	700074
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nein
2nd row	Nein
3rd row	Nein
4th row	Nein
5th row	Nein

Common Values

Value	Count	Frequency (%)
Nein	167975	72.9%
Ja	14087	6.1%
(Missing)	48374	21.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
nein	167975	92.3%
ja	14087	7.7%

Most occurring characters

Value	Count	Frequency (%)
N	167975	24.0%
e	167975	24.0%
i	167975	24.0%
n	167975	24.0%
J	14087	2.0%
a	14087	2.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	518012	74.0%
Uppercase Letter	182062	26.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	167975	32.4%
i	167975	32.4%
n	167975	32.4%
a	14087	2.7%

Uppercase Letter

Value	Count	Frequency (%)
N	167975	92.3%
J	14087	7.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	700074	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	167975	24.0%
e	167975	24.0%
i	167975	24.0%
n	167975	24.0%
J	14087	2.0%
a	14087	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	700074	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	167975	24.0%
e	167975	24.0%
i	167975	24.0%
n	167975	24.0%
J	14087	2.0%
a	14087	2.0%

device_type
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	82382
Missing (%)	35.8%
Memory size	225.3 KiB

Desktop	99793
Smartphone	48261

Length

Max length	10
Median length	7
Mean length	7.97790671
Min length	7

Characters and Unicode

Total characters	1181161
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Desktop
2nd row	Desktop
3rd row	Desktop
4th row	Desktop
5th row	Desktop

Common Values

Value	Count	Frequency (%)
Desktop	99793	43.3%
Smartphone	48261	20.9%
(Missing)	82382	35.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
desktop	99793	67.4%
smartphone	48261	32.6%

Most occurring characters

Value	Count	Frequency (%)
e	148054	12.5%
t	148054	12.5%
o	148054	12.5%
p	148054	12.5%
D	99793	8.4%
s	99793	8.4%
k	99793	8.4%
S	48261	4.1%
m	48261	4.1%
a	48261	4.1%
Other values (3)	144783	12.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1033107	87.5%
Uppercase Letter	148054	12.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	148054	14.3%
t	148054	14.3%
o	148054	14.3%
p	148054	14.3%
s	99793	9.7%
k	99793	9.7%
m	48261	4.7%
a	48261	4.7%
r	48261	4.7%
h	48261	4.7%

Uppercase Letter

Value	Count	Frequency (%)
D	99793	67.4%
S	48261	32.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1181161	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	148054	12.5%
t	148054	12.5%
o	148054	12.5%
p	148054	12.5%
D	99793	8.4%
s	99793	8.4%
k	99793	8.4%
S	48261	4.1%
m	48261	4.1%
a	48261	4.1%
Other values (3)	144783	12.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1181161	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	148054	12.5%
t	148054	12.5%
o	148054	12.5%
p	148054	12.5%
D	99793	8.4%
s	99793	8.4%
k	99793	8.4%
S	48261	4.1%
m	48261	4.1%
a	48261	4.1%
Other values (3)	144783	12.3%

dispcode
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	82382
Missing (%)	35.8%
Memory size	225.3 KiB

Beendet	113620
Ausgescreent	31459
Beendet nach Unterbrechung	2975

Length

Max length	26
Median length	7
Mean length	8.444202791
Min length	7

Characters and Unicode

Total characters	1250198
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Beendet
2nd row	Ausgescreent
3rd row	Beendet
4th row	Beendet
5th row	Beendet

Common Values

Value	Count	Frequency (%)
Beendet	113620	49.3%
Ausgescreent	31459	13.7%
Beendet nach Unterbrechung	2975	1.3%
(Missing)	82382	35.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
beendet	116595	75.7%
ausgescreent	31459	20.4%
nach	2975	1.9%
unterbrechung	2975	1.9%

Most occurring characters

Value	Count	Frequency (%)
e	450112	36.0%
n	156979	12.6%
t	151029	12.1%
B	116595	9.3%
d	116595	9.3%
s	62918	5.0%
c	37409	3.0%
r	37409	3.0%
u	34434	2.8%
g	34434	2.8%
Other values (6)	52284	4.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1093219	87.4%
Uppercase Letter	151029	12.1%
Space Separator	5950	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	450112	41.2%
n	156979	14.4%
t	151029	13.8%
d	116595	10.7%
s	62918	5.8%
c	37409	3.4%
r	37409	3.4%
u	34434	3.1%
g	34434	3.1%
h	5950	0.5%
Other values (2)	5950	0.5%

Uppercase Letter

Value	Count	Frequency (%)
B	116595	77.2%
A	31459	20.8%
U	2975	2.0%

Space Separator

Value	Count	Frequency (%)
	5950	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1244248	99.5%
Common	5950	0.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	450112	36.2%
n	156979	12.6%
t	151029	12.1%
B	116595	9.4%
d	116595	9.4%
s	62918	5.1%
c	37409	3.0%
r	37409	3.0%
u	34434	2.8%
g	34434	2.8%
Other values (5)	46334	3.7%

Common

Value	Count	Frequency (%)
	5950	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1250198	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	450112	36.0%
n	156979	12.6%
t	151029	12.1%
B	116595	9.3%
d	116595	9.3%
s	62918	5.0%
c	37409	3.0%
r	37409	3.0%
u	34434	2.8%
g	34434	2.8%
Other values (6)	52284	4.2%

u_ticket
Categorical

HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	40694
Missing (%)	17.7%
Memory size	225.4 KiB

Mobile-Ticket	157799
Online-Ticket	25161
Easy Ride	6463
bedienter Vertrieb	319

Length

Max length	18
Median length	13
Mean length	12.87215798
Min length	9

Characters and Unicode

Total characters	2442389
Distinct characters	22
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mobile-Ticket
2nd row	Mobile-Ticket
3rd row	Mobile-Ticket
4th row	Mobile-Ticket
5th row	Mobile-Ticket

Common Values

Value	Count	Frequency (%)
Mobile-Ticket	157799	68.5%
Online-Ticket	25161	10.9%
Easy Ride	6463	2.8%
bedienter Vertrieb	319	0.1%
(Missing)	40694	17.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
mobile-ticket	157799	80.3%
online-ticket	25161	12.8%
easy	6463	3.3%
ride	6463	3.3%
bedienter	319	0.2%
vertrieb	319	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	373978	15.3%
i	373021	15.3%
t	183598	7.5%
l	182960	7.5%
-	182960	7.5%
T	182960	7.5%
c	182960	7.5%
k	182960	7.5%
b	158437	6.5%
M	157799	6.5%
Other values (12)	280756	11.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1873482	76.7%
Uppercase Letter	379165	15.5%
Dash Punctuation	182960	7.5%
Space Separator	6782	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	373978	20.0%
i	373021	19.9%
t	183598	9.8%
l	182960	9.8%
c	182960	9.8%
k	182960	9.8%
b	158437	8.5%
o	157799	8.4%
n	50641	2.7%
d	6782	0.4%
Other values (4)	20346	1.1%

Uppercase Letter

Value	Count	Frequency (%)
T	182960	48.3%
M	157799	41.6%
O	25161	6.6%
E	6463	1.7%
R	6463	1.7%
V	319	0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	182960	100.0%

Space Separator

Value	Count	Frequency (%)
	6782	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2252647	92.2%
Common	189742	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	373978	16.6%
i	373021	16.6%
t	183598	8.2%
l	182960	8.1%
T	182960	8.1%
c	182960	8.1%
k	182960	8.1%
b	158437	7.0%
M	157799	7.0%
o	157799	7.0%
Other values (10)	116175	5.2%

Common

Value	Count	Frequency (%)
-	182960	96.4%
	6782	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2442389	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	373978	15.3%
i	373021	15.3%
t	183598	7.5%
l	182960	7.5%
-	182960	7.5%
T	182960	7.5%
c	182960	7.5%
k	182960	7.5%
b	158437	6.5%
M	157799	6.5%
Other values (12)	280756	11.5%

u_fahrausweis
Categorical

HIGH CORRELATION
MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	110636
Missing (%)	48.0%
Memory size	225.5 KiB

Normales Billett	91847
GA	15699
Sparbillett	8084
Spartageskarte	3416
Tageskarte	459
Other values (2)	295

Length

Max length	18
Median length	16
Mean length	13.74565109
Min length	2

Characters and Unicode

Total characters	1646729
Distinct characters	30
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Normales Billett
2nd row	Normales Billett
3rd row	Normales Billett
4th row	Normales Billett
5th row	Normales Billett

Common Values

Value	Count	Frequency (%)
Normales Billett	91847	39.9%
GA	15699	6.8%
Sparbillett	8084	3.5%
Spartageskarte	3416	1.5%
Tageskarte	459	0.2%
Strecken-/Modulabo	216	0.1%
seven25	79	< 0.1%
(Missing)	110636	48.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
normales	91847	43.4%
billett	91847	43.4%
ga	15699	7.4%
sparbillett	8084	3.8%
spartageskarte	3416	1.6%
tageskarte	459	0.2%
strecken-/modulabo	216	0.1%
seven25	79	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
l	291925	17.7%
t	207369	12.6%
e	200118	12.2%
a	111313	6.8%
r	107438	6.5%
i	99931	6.1%
s	95801	5.8%
o	92279	5.6%
N	91847	5.6%
m	91847	5.6%
Other values (20)	256861	15.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1326809	80.6%
Uppercase Letter	227483	13.8%
Space Separator	91847	5.6%
Dash Punctuation	216	< 0.1%
Other Punctuation	216	< 0.1%
Decimal Number	158	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	291925	22.0%
t	207369	15.6%
e	200118	15.1%
a	111313	8.4%
r	107438	8.1%
i	99931	7.5%
s	95801	7.2%
o	92279	7.0%
m	91847	6.9%
p	11500	0.9%
Other values (8)	17288	1.3%

Uppercase Letter

Value	Count	Frequency (%)
N	91847	40.4%
B	91847	40.4%
G	15699	6.9%
A	15699	6.9%
S	11716	5.2%
T	459	0.2%
M	216	0.1%

Decimal Number

Value	Count	Frequency (%)
2	79	50.0%
5	79	50.0%

Space Separator

Value	Count	Frequency (%)
	91847	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	216	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	216	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1554292	94.4%
Common	92437	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	291925	18.8%
t	207369	13.3%
e	200118	12.9%
a	111313	7.2%
r	107438	6.9%
i	99931	6.4%
s	95801	6.2%
o	92279	5.9%
N	91847	5.9%
m	91847	5.9%
Other values (15)	164424	10.6%

Common

Value	Count	Frequency (%)
	91847	99.4%
-	216	0.2%
/	216	0.2%
2	79	0.1%
5	79	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1646729	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	291925	17.7%
t	207369	12.6%
e	200118	12.2%
a	111313	6.8%
r	107438	6.5%
i	99931	6.1%
s	95801	5.8%
o	92279	5.6%
N	91847	5.6%
m	91847	5.6%
Other values (20)	256861	15.6%

u_preis
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct	1452
Distinct (%)	0.7%
Missing	22060
Missing (%)	9.6%
Infinite	0
Infinite (%)	0.0%
Mean	33.51653165

Minimum	0
Maximum	6300
Zeros	42
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	3.8
Q1	8.2
median	16
Q3	29.1
95-th percentile	61
Maximum	6300
Range	6300
Interquartile range (IQR)	20.9

Descriptive statistics

Standard deviation	204.0820667
Coefficient of variation (CV)	6.088997179
Kurtosis	449.324539
Mean	33.51653165
Median Absolute Deviation (MAD)	9.2
Skewness	20.00160275
Sum	6984040.8
Variance	41649.48994
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	4883	2.1%
6.8	4779	2.1%
3.4	3955	1.7%
8.8	3022	1.3%
6.2	2826	1.2%
28	2457	1.1%
5.8	2410	1.0%
14	2392	1.0%
3.7	2344	1.0%
17	2337	1.0%
Other values (1442)	176971	76.8%
(Missing)	22060	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	42	< 0.1%
0.5	2	< 0.1%
1.3	2	< 0.1%
1.4	10	< 0.1%
1.5	7	< 0.1%
1.7	2	< 0.1%
2	304	0.1%
2.1	4	< 0.1%
2.2	396	0.2%
2.3	4	< 0.1%

Value	Count	Frequency (%)
6300	55	< 0.1%
4840	22	< 0.1%
4520	1	< 0.1%
4340	11	< 0.1%
4050	4	< 0.1%
3860	200	0.1%
3520	1	< 0.1%
2880	130	0.1%
2700	75	< 0.1%
2650	110	< 0.1%

R_zweck
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	5509
Missing (%)	2.4%
Memory size	225.3 KiB

Freizeit und Unterhaltung	149802
Arbeit und Lernen	59999
Sonstige	15126

Length

Max length	25
Median length	25
Mean length	21.72278561
Min length	8

Characters and Unicode

Total characters	4886041
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Freizeit und Unterhaltung
2nd row	Freizeit und Unterhaltung
3rd row	Freizeit und Unterhaltung
4th row	Freizeit und Unterhaltung
5th row	Sonstige

Common Values

Value	Count	Frequency (%)
Freizeit und Unterhaltung	149802	65.0%
Arbeit und Lernen	59999	26.0%
Sonstige	15126	6.6%
(Missing)	5509	2.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
und	209801	32.6%
freizeit	149802	23.2%
unterhaltung	149802	23.2%
arbeit	59999	9.3%
lernen	59999	9.3%
sonstige	15126	2.3%

Most occurring characters

Value	Count	Frequency (%)
e	644529	13.2%
n	644529	13.2%
t	524531	10.7%
	419602	8.6%
r	419602	8.6%
i	374729	7.7%
u	359603	7.4%
d	209801	4.3%
g	164928	3.4%
F	149802	3.1%
Other values (11)	974385	19.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4031711	82.5%
Uppercase Letter	434728	8.9%
Space Separator	419602	8.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	644529	16.0%
n	644529	16.0%
t	524531	13.0%
r	419602	10.4%
i	374729	9.3%
u	359603	8.9%
d	209801	5.2%
g	164928	4.1%
a	149802	3.7%
l	149802	3.7%
Other values (5)	389855	9.7%

Uppercase Letter

Value	Count	Frequency (%)
F	149802	34.5%
U	149802	34.5%
A	59999	13.8%
L	59999	13.8%
S	15126	3.5%

Space Separator

Value	Count	Frequency (%)
	419602	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4466439	91.4%
Common	419602	8.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	644529	14.4%
n	644529	14.4%
t	524531	11.7%
r	419602	9.4%
i	374729	8.4%
u	359603	8.1%
d	209801	4.7%
g	164928	3.7%
F	149802	3.4%
a	149802	3.4%
Other values (10)	824583	18.5%

Common

Value	Count	Frequency (%)
	419602	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4886041	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	644529	13.2%
n	644529	13.2%
t	524531	10.7%
	419602	8.6%
r	419602	8.6%
i	374729	7.7%
u	359603	7.4%
d	209801	4.3%
g	164928	3.4%
F	149802	3.1%
Other values (11)	974385	19.9%

ft_abfahrt
Date

MISSING

Distinct	1318
Distinct (%)	0.7%
Missing	38826
Missing (%)	16.8%
Memory size	1.8 MiB

Minimum	2022-11-25 00:00:00
Maximum	2022-11-25 23:59:00

Histogram

Histogram with fixed size bins (bins=50)

ft_ankunft
Date

MISSING

Distinct	1333
Distinct (%)	0.7%
Missing	38826
Missing (%)	16.8%
Memory size	1.8 MiB

Minimum	2022-11-25 00:00:00
Maximum	2022-11-25 23:59:00

Histogram

Histogram with fixed size bins (bins=50)

ft_startort_uic
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct	2367
Distinct (%)	1.2%
Missing	38826
Missing (%)	16.8%
Infinite	0
Infinite (%)	0.0%
Mean	8508835.287

Minimum	1101961
Maximum	8891702
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1101961
5-th percentile	8500023
Q1	8503000
median	8504300
Q3	8507000
95-th percentile	8576333
Maximum	8891702
Range	7789741
Interquartile range (IQR)	4000

Descriptive statistics

Standard deviation	51743.56461
Coefficient of variation (CV)	0.006081157158
Kurtosis	4640.554582
Mean	8508835.287
Median Absolute Deviation (MAD)	2177
Skewness	-38.67778891
Sum	1.630377929 × 10¹²
Variance	2677396478
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8503000	20537	8.9%
8507000	11470	5.0%
8500010	7514	3.3%
8505000	6937	3.0%
8503016	5677	2.5%
8500218	5371	2.3%
8506000	4274	1.9%
8506302	3125	1.4%
8509000	2443	1.1%
8502204	2403	1.0%
Other values (2357)	121859	52.9%
(Missing)	38826	16.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1101961	2	< 0.1%
5103865	1	< 0.1%
5510017	2	< 0.1%
8001071	18	< 0.1%
8001093	1	< 0.1%
8002084	1	< 0.1%
8002140	1	< 0.1%
8002181	3	< 0.1%
8002253	3	< 0.1%
8002301	2	< 0.1%

Value	Count	Frequency (%)
8891702	1	< 0.1%
8812005	1	< 0.1%
8775100	1	< 0.1%
8774687	1	< 0.1%
8774549	3	< 0.1%
8771513	1	< 0.1%
8771304	5	< 0.1%
8718206	4	< 0.1%
8596004	10	< 0.1%
8595931	1	< 0.1%

ft_tu
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	55
Distinct (%)	< 0.1%
Missing	38826
Missing (%)	16.8%
Memory size	227.6 KiB

SBB	149604
BLS	10586
SOB	7642
THU	6964
RhB	4497
Other values (50)	12317

Length

Max length	3
Median length	3
Mean length	2.97306508
Min length	1

Characters and Unicode

Total characters	569669
Distinct characters	31
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	THU
2nd row	SBB
3rd row	SBB
4th row	SBB
5th row	SBB

Common Values

Value	Count	Frequency (%)
SBB	149604	64.9%
BLS	10586	4.6%
SOB	7642	3.3%
THU	6964	3.0%
RhB	4497	2.0%
ZB	3431	1.5%
MGB	1727	0.7%
AVA	1126	0.5%
RBS	1021	0.4%
AB-	982	0.4%
Other values (45)	4030	1.7%
(Missing)	38826	16.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sbb	149604	78.1%
bls	10586	5.5%
sob	7642	4.0%
thu	6964	3.6%
rhb	4497	2.3%
zb	3433	1.8%
mgb	1727	0.9%
ava	1126	0.6%
rbs	1021	0.5%
ab	982	0.5%
Other values (43)	4028	2.1%

Most occurring characters

Value	Count	Frequency (%)
B	331037	58.1%
S	169811	29.8%
L	10713	1.9%
O	8170	1.4%
U	7539	1.3%
T	7436	1.3%
H	6964	1.2%
R	6275	1.1%
h	4497	0.8%
A	4365	0.8%
Other values (21)	12862	2.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	564064	99.0%
Lowercase Letter	4614	0.8%
Dash Punctuation	984	0.2%
Connector Punctuation	7	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	331037	58.7%
S	169811	30.1%
L	10713	1.9%
O	8170	1.4%
U	7539	1.3%
T	7436	1.3%
H	6964	1.2%
R	6275	1.1%
A	4365	0.8%
Z	4008	0.7%
Other values (15)	7746	1.4%

Lowercase Letter

Value	Count	Frequency (%)
h	4497	97.5%
e	65	1.4%
r	42	0.9%
t	10	0.2%

Dash Punctuation

Value	Count	Frequency (%)
-	984	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	568678	99.8%
Common	991	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	331037	58.2%
S	169811	29.9%
L	10713	1.9%
O	8170	1.4%
U	7539	1.3%
T	7436	1.3%
H	6964	1.2%
R	6275	1.1%
h	4497	0.8%
A	4365	0.8%
Other values (19)	11871	2.1%

Common

Value	Count	Frequency (%)
-	984	99.3%
_	7	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	569619	> 99.9%
None	50	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	331037	58.1%
S	169811	29.8%
L	10713	1.9%
O	8170	1.4%
U	7539	1.3%
T	7436	1.3%
H	6964	1.2%
R	6275	1.1%
h	4497	0.8%
A	4365	0.8%
Other values (19)	12812	2.2%

None

Value	Count	Frequency (%)
Ö	49	98.0%
Ü	1	2.0%

ft_vm
Categorical

HIGH CARDINALITY
MISSING

Distinct	18455
Distinct (%)	9.6%
Missing	38826
Missing (%)	16.8%
Memory size	1.1 MiB

IC 5	578
IC 8	462
IC 8 808	436
IC 1	416
IC 8 825	405
Other values (18450)	189313

Length

Max length	14
Median length	13
Mean length	8.927101926
Min length	3

Characters and Unicode

Total characters	1710522
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6317 ?
Unique (%)	3.3%

Sample

1st row	S 30
2nd row	IR 36 2057
3rd row	IR 75 2128
4th row	IC 8 817
5th row	S 25 8540

Common Values

Value	Count	Frequency (%)
IC 5	578	0.3%
IC 8	462	0.2%
IC 8 808	436	0.2%
IC 1	416	0.2%
IC 8 825	405	0.2%
IC 8 827	402	0.2%
IC 8 829	381	0.2%
IC 8 826	362	0.2%
IC 8 810	357	0.2%
IC 8 806	338	0.1%
Other values (18445)	187473	81.4%
(Missing)	38826	16.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
s	53333	11.0%
ic	43944	9.1%
ir	40063	8.3%
5	13758	2.8%
8	12727	2.6%
1	11059	2.3%
3	10258	2.1%
re	8787	1.8%
75	6599	1.4%
r	5507	1.1%
Other values (14669)	277797	57.4%

Most occurring characters

Value	Count	Frequency (%)
	309168	18.1%
1	199142	11.6%
2	153441	9.0%
I	112544	6.6%
5	110242	6.4%
3	103891	6.1%
6	93494	5.5%
8	88498	5.2%
7	85324	5.0%
R	69003	4.0%
Other values (13)	385775	22.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1010970	59.1%
Uppercase Letter	323378	18.9%
Space Separator	309168	18.1%
Dash Punctuation	67006	3.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	112544	34.8%
R	69003	21.3%
C	65713	20.3%
S	56382	17.4%
E	18012	5.6%
G	530	0.2%
T	519	0.2%
V	519	0.2%
N	121	< 0.1%
L	33	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	199142	19.7%
2	153441	15.2%
5	110242	10.9%
3	103891	10.3%
6	93494	9.2%
8	88498	8.8%
7	85324	8.4%
4	63933	6.3%
0	57150	5.7%
9	55855	5.5%

Space Separator

Value	Count	Frequency (%)
	309168	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	67006	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1387144	81.1%
Latin	323378	18.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
	309168	22.3%
1	199142	14.4%
2	153441	11.1%
5	110242	7.9%
3	103891	7.5%
6	93494	6.7%
8	88498	6.4%
7	85324	6.2%
-	67006	4.8%
4	63933	4.6%
Other values (2)	113005	8.1%

Latin

Value	Count	Frequency (%)
I	112544	34.8%
R	69003	21.3%
C	65713	20.3%
S	56382	17.4%
E	18012	5.6%
G	530	0.2%
T	519	0.2%
V	519	0.2%
N	121	< 0.1%
L	33	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1710522	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	309168	18.1%
1	199142	11.6%
2	153441	9.0%
I	112544	6.6%
5	110242	6.4%
3	103891	6.1%
6	93494	5.5%
8	88498	5.2%
7	85324	5.0%
R	69003	4.0%
Other values (13)	385775	22.6%

ft_vm_kurz
Categorical

HIGH CORRELATION
MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	38826
Missing (%)	16.8%
Memory size	225.5 KiB

IC	57796
S	56268
IR	52053
RE	10042
R	6868
Other values (7)	8583

Length

Max length	3
Median length	2
Mean length	1.687271019
Min length	1

Characters and Unicode

Total characters	323298
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	S
2nd row	IR
3rd row	IR
4th row	IC
5th row	S

Common Values

Value	Count	Frequency (%)
IC	57796	25.1%
S	56268	24.4%
IR	52053	22.6%
RE	10042	4.4%
R	6868	3.0%
EC	5247	2.3%
ICE	2670	1.2%
TGV	519	0.2%
SN	113	< 0.1%
IRE	25	< 0.1%
Other values (2)	9	< 0.1%
(Missing)	38826	16.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ic	57796	30.2%
s	56268	29.4%
ir	52053	27.2%
re	10042	5.2%
r	6868	3.6%
ec	5247	2.7%
ice	2670	1.4%
tgv	519	0.3%
sn	113	0.1%
ire	25	< 0.1%
Other values (2)	9	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
I	112544	34.8%
R	68988	21.3%
C	65713	20.3%
S	56382	17.4%
E	17992	5.6%
T	519	0.2%
G	519	0.2%
V	519	0.2%
N	121	< 0.1%
L	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	323298	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	112544	34.8%
R	68988	21.3%
C	65713	20.3%
S	56382	17.4%
E	17992	5.6%
T	519	0.2%
G	519	0.2%
V	519	0.2%
N	121	< 0.1%
L	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	323298	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	112544	34.8%
R	68988	21.3%
C	65713	20.3%
S	56382	17.4%
E	17992	5.6%
T	519	0.2%
G	519	0.2%
V	519	0.2%
N	121	< 0.1%
L	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	323298	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	112544	34.8%
R	68988	21.3%
C	65713	20.3%
S	56382	17.4%
E	17992	5.6%
T	519	0.2%
G	519	0.2%
V	519	0.2%
N	121	< 0.1%
L	1	< 0.1%

ft_zielort_uic
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	1465
Distinct (%)	0.8%
Missing	38826
Missing (%)	16.8%
Infinite	0
Infinite (%)	0.0%
Mean	8500547.145

Minimum	5501362
Maximum	8814001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	5501362
5-th percentile	8500023
Q1	8503000
median	8503126
Q3	8506290
95-th percentile	8509000
Maximum	8814001
Range	3312639
Interquartile range (IQR)	3290

Descriptive statistics

Standard deviation	42578.66709
Coefficient of variation (CV)	0.005008932527
Kurtosis	613.9175755
Mean	8500547.145
Median Absolute Deviation (MAD)	1874
Skewness	-16.82378465
Sum	1.628789838 × 10¹²
Variance	1812942891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8503000	35863	15.6%
8507000	17492	7.6%
8505000	10165	4.4%
8500218	8378	3.6%
8500010	7372	3.2%
8506000	5505	2.4%
8506302	4678	2.0%
8503016	3806	1.7%
8509000	3799	1.6%
8502113	2896	1.3%
Other values (1455)	91656	39.8%
(Missing)	38826	16.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5501362	1	< 0.1%
5510017	3	< 0.1%
8001071	15	< 0.1%
8001093	1	< 0.1%
8002140	1	< 0.1%
8002181	3	< 0.1%
8002253	3	< 0.1%
8002301	2	< 0.1%
8002307	1	< 0.1%
8002371	7	< 0.1%

Value	Count	Frequency (%)
8814001	1	< 0.1%
8774647	1	< 0.1%
8774600	1	< 0.1%
8774549	6	< 0.1%
8774538	1	< 0.1%
8772568	1	< 0.1%
8772319	1	< 0.1%
8771513	1	< 0.1%
8771304	5	< 0.1%
8768888	1	< 0.1%

fg_abfahrt
Date

MISSING

Distinct	1342
Distinct (%)	0.7%
Missing	27962
Missing (%)	12.1%
Memory size	1.8 MiB

Minimum	2022-11-25 00:00:00
Maximum	2022-11-25 23:59:00

Histogram

Histogram with fixed size bins (bins=50)

fg_ankunft
Date

MISSING

Distinct	1366
Distinct (%)	0.7%
Missing	27962
Missing (%)	12.1%
Memory size	1.8 MiB

Minimum	2022-11-25 00:00:00
Maximum	2022-11-25 23:59:00

Histogram

Histogram with fixed size bins (bins=50)

fg_startort_uic
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct	10855
Distinct (%)	5.4%
Missing	27962
Missing (%)	12.1%
Infinite	0
Infinite (%)	0.0%
Mean	8509955.09

Minimum	1101316
Maximum	8891702
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1101316
5-th percentile	8500026
Q1	8503000
median	8505000
Q3	8507493
95-th percentile	8587758
Maximum	8891702
Range	7790386
Interquartile range (IQR)	4493

Descriptive statistics

Standard deviation	108560.3254
Coefficient of variation (CV)	0.01275686231
Kurtosis	3628.066665
Mean	8509955.09
Median Absolute Deviation (MAD)	2173
Skewness	-54.04320342
Sum	1.723044647 × 10¹²
Variance	1.178534424 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8503000	13395	5.8%
8507000	8458	3.7%
8500010	6957	3.0%
8503016	5883	2.6%
8505000	5838	2.5%
8506000	3328	1.4%
8500218	2598	1.1%
8506302	2537	1.1%
8502113	2038	0.9%
8507100	1970	0.9%
Other values (10845)	149472	64.9%
(Missing)	27962	12.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1101316	1	< 0.1%
1101327	1	< 0.1%
1101954	1	< 0.1%
1101957	1	< 0.1%
1102034	1	< 0.1%
1104935	1	< 0.1%
1106493	27	< 0.1%
1401810	1	< 0.1%
5103865	1	< 0.1%
5510017	2	< 0.1%

Value	Count	Frequency (%)
8891702	1	< 0.1%
8812005	1	< 0.1%
8776302	1	< 0.1%
8775100	1	< 0.1%
8774687	2	< 0.1%
8774600	3	< 0.1%
8774564	2	< 0.1%
8774549	4	< 0.1%
8774232	1	< 0.1%
8772319	7	< 0.1%

fg_zielort_uic
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct	10648
Distinct (%)	5.3%
Missing	27962
Missing (%)	12.1%
Infinite	0
Infinite (%)	0.0%
Mean	8507632.266

Minimum	1101322
Maximum	8831138
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1101322
5-th percentile	8500023
Q1	8503000
median	8505000
Q3	8507483
95-th percentile	8588581
Maximum	8831138
Range	7729816
Interquartile range (IQR)	4483

Descriptive statistics

Standard deviation	132484.0222
Coefficient of variation (CV)	0.01557237291
Kurtosis	2521.216593
Mean	8507632.266
Median Absolute Deviation (MAD)	2060
Skewness	-45.87708909
Sum	1.722574335 × 10¹²
Variance	1.755201614 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8503000	18400	8.0%
8507000	10195	4.4%
8505000	6997	3.0%
8500010	6783	2.9%
8503016	4943	2.1%
8506000	4166	1.8%
8506302	3589	1.6%
8500218	2731	1.2%
8502113	2502	1.1%
8507100	1971	0.9%
Other values (10638)	140197	60.8%
(Missing)	27962	12.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1101322	1	< 0.1%
1101323	1	< 0.1%
1101535	1	< 0.1%
1101894	2	< 0.1%
1101957	3	< 0.1%
1101966	2	< 0.1%
1102138	2	< 0.1%
1102502	1	< 0.1%
1106493	31	< 0.1%
1110000	1	< 0.1%

Value	Count	Frequency (%)
8831138	1	< 0.1%
8814001	1	< 0.1%
8774700	2	< 0.1%
8774687	1	< 0.1%
8774647	1	< 0.1%
8774600	1	< 0.1%
8774564	1	< 0.1%
8774559	1	< 0.1%
8774549	8	< 0.1%
8774538	1	< 0.1%

fg_startort
Categorical

HIGH CARDINALITY
MISSING

Distinct	12200
Distinct (%)	5.5%
Missing	6747
Missing (%)	2.9%
Memory size	803.5 KiB

Zürich HB	14392
Bern	9061
Basel SBB	7562
Luzern	6269
Zürich Flughafen	6251
Other values (12195)	180154

Length

Max length	33
Median length	26
Mean length	11.27542704
Min length	1

Characters and Unicode

Total characters	2522189
Distinct characters	92
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3873 ?
Unique (%)	1.7%

Sample

1st row	Frauenfeld
2nd row	Rheinfelden
3rd row	Amriswil
4th row	Salgesch
5th row	Dottikon-Dintikon

Common Values

Value	Count	Frequency (%)
Zürich HB	14392	6.2%
Bern	9061	3.9%
Basel SBB	7562	3.3%
Luzern	6269	2.7%
Zürich Flughafen	6251	2.7%
Winterthur	3627	1.6%
Olten	2822	1.2%
St. Gallen	2688	1.2%
Aarau	2159	0.9%
Thun	2089	0.9%
Other values (12190)	166769	72.4%
(Missing)	6747	2.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
zürich	28091	8.1%
hb	14626	4.2%
bern	11158	3.2%
basel	9040	2.6%
sbb	7845	2.3%
luzern	7183	2.1%
flughafen	6383	1.8%
st	5067	1.5%
winterthur	4990	1.4%
dorf	4272	1.2%
Other values (9227)	246613	71.4%

Most occurring characters

Value	Count	Frequency (%)
e	247729	9.8%
n	197313	7.8%
r	180868	7.2%
i	138984	5.5%
a	138547	5.5%
	121639	4.8%
l	120111	4.8%
t	112420	4.5%
h	109145	4.3%
s	94950	3.8%
Other values (82)	1060483	42.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1911521	75.8%
Uppercase Letter	419661	16.6%
Space Separator	121639	4.8%
Other Punctuation	55609	2.2%
Dash Punctuation	9934	0.4%
Close Punctuation	1810	0.1%
Open Punctuation	1810	0.1%
Decimal Number	198	< 0.1%
Math Symbol	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	247729	13.0%
n	197313	10.3%
r	180868	9.5%
i	138984	7.3%
a	138547	7.2%
l	120111	6.3%
t	112420	5.9%
h	109145	5.7%
s	94950	5.0%
o	79675	4.2%
Other values (31)	491779	25.7%

Uppercase Letter

Value	Count	Frequency (%)
B	82021	19.5%
S	48950	11.7%
Z	39878	9.5%
H	29055	6.9%
L	23569	5.6%
G	23212	5.5%
W	20220	4.8%
A	18514	4.4%
F	16136	3.8%
R	14731	3.5%
Other values (23)	103375	24.6%

Decimal Number

Value	Count	Frequency (%)
4	75	37.9%
6	31	15.7%
3	27	13.6%
0	25	12.6%
1	17	8.6%
2	12	6.1%
7	10	5.1%
8	1	0.5%

Other Punctuation

Value	Count	Frequency (%)
,	43186	77.7%
.	7751	13.9%
/	4524	8.1%
'	147	0.3%
&	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	121639	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9934	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1810	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1810	100.0%

Math Symbol

Value	Count	Frequency (%)
+	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2331182	92.4%
Common	191007	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	247729	10.6%
n	197313	8.5%
r	180868	7.8%
i	138984	6.0%
a	138547	5.9%
l	120111	5.2%
t	112420	4.8%
h	109145	4.7%
s	94950	4.1%
B	82021	3.5%
Other values (64)	909094	39.0%

Common

Value	Count	Frequency (%)
	121639	63.7%
,	43186	22.6%
-	9934	5.2%
.	7751	4.1%
/	4524	2.4%
)	1810	0.9%
(	1810	0.9%
'	147	0.1%
4	75	< 0.1%
6	31	< 0.1%
Other values (8)	100	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2465514	97.8%
None	56675	2.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	247729	10.0%
n	197313	8.0%
r	180868	7.3%
i	138984	5.6%
a	138547	5.6%
	121639	4.9%
l	120111	4.9%
t	112420	4.6%
h	109145	4.4%
s	94950	3.9%
Other values (60)	1003808	40.7%

None

Value	Count	Frequency (%)
ü	41875	73.9%
ä	7432	13.1%
ö	3878	6.8%
è	1317	2.3%
é	1089	1.9%
â	469	0.8%
Ü	369	0.7%
Ä	95	0.2%
ô	40	0.1%
Ö	34	0.1%
Other values (12)	77	0.1%

fg_zielort
Categorical

HIGH CARDINALITY
MISSING

Distinct	12048
Distinct (%)	5.4%
Missing	6744
Missing (%)	2.9%
Memory size	802.4 KiB

Zürich HB	19777
Bern	10863
Luzern	7516
Basel SBB	7434
Zürich Flughafen	5242
Other values (12043)	172860

Length

Max length	40
Median length	28
Mean length	11.18388677
Min length	2

Characters and Unicode

Total characters	2501746
Distinct characters	95
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4134 ?
Unique (%)	1.8%

Sample

1st row	Seuzach
2nd row	Lugano
3rd row	Richterswil
4th row	Interlaken West
5th row	Brugg AG

Common Values

Value	Count	Frequency (%)
Zürich HB	19777	8.6%
Bern	10863	4.7%
Luzern	7516	3.3%
Basel SBB	7434	3.2%
Zürich Flughafen	5242	2.3%
Winterthur	4476	1.9%
St. Gallen	3781	1.6%
Olten	2950	1.3%
Aarau	2686	1.2%
Chur	2114	0.9%
Other values (12038)	156853	68.1%
(Missing)	6744	2.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
zürich	38145	10.9%
hb	20146	5.7%
bern	13773	3.9%
basel	9074	2.6%
luzern	8866	2.5%
sbb	7679	2.2%
st	6607	1.9%
winterthur	5490	1.6%
flughafen	5456	1.6%
gallen	5288	1.5%
Other values (9203)	230324	65.6%

Most occurring characters

Value	Count	Frequency (%)
e	234359	9.4%
n	188545	7.5%
r	186651	7.5%
i	139606	5.6%
a	138496	5.5%
	127265	5.1%
l	117492	4.7%
h	114786	4.6%
t	109174	4.4%
s	89648	3.6%
Other values (85)	1055724	42.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1877290	75.0%
Uppercase Letter	428640	17.1%
Space Separator	127265	5.1%
Other Punctuation	55860	2.2%
Dash Punctuation	8394	0.3%
Open Punctuation	2025	0.1%
Close Punctuation	2025	0.1%
Decimal Number	227	< 0.1%
Math Symbol	20	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	234359	12.5%
n	188545	10.0%
r	186651	9.9%
i	139606	7.4%
a	138496	7.4%
l	117492	6.3%
h	114786	6.1%
t	109174	5.8%
s	89648	4.8%
u	77519	4.1%
Other values (33)	481014	25.6%

Uppercase Letter

Value	Count	Frequency (%)
B	89334	20.8%
Z	48744	11.4%
S	48422	11.3%
H	32815	7.7%
L	24572	5.7%
G	22652	5.3%
W	18594	4.3%
A	18009	4.2%
F	14383	3.4%
R	13581	3.2%
Other values (22)	97534	22.8%

Decimal Number

Value	Count	Frequency (%)
4	77	33.9%
3	30	13.2%
6	26	11.5%
1	24	10.6%
0	22	9.7%
2	21	9.3%
7	19	8.4%
8	4	1.8%
9	2	0.9%
5	2	0.9%

Other Punctuation

Value	Count	Frequency (%)
,	41438	74.2%
.	8904	15.9%
/	5397	9.7%
'	119	0.2%
&	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	127265	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8394	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2025	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2025	100.0%

Math Symbol

Value	Count	Frequency (%)
+	20	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2305930	92.2%
Common	195816	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	234359	10.2%
n	188545	8.2%
r	186651	8.1%
i	139606	6.1%
a	138496	6.0%
l	117492	5.1%
h	114786	5.0%
t	109174	4.7%
s	89648	3.9%
B	89334	3.9%
Other values (65)	897839	38.9%

Common

Value	Count	Frequency (%)
	127265	65.0%
,	41438	21.2%
.	8904	4.5%
-	8394	4.3%
/	5397	2.8%
(	2025	1.0%
)	2025	1.0%
'	119	0.1%
4	77	< 0.1%
3	30	< 0.1%
Other values (10)	142	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2438705	97.5%
None	63041	2.5%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	234359	9.6%
n	188545	7.7%
r	186651	7.7%
i	139606	5.7%
a	138496	5.7%
	127265	5.2%
l	117492	4.8%
h	114786	4.7%
t	109174	4.5%
s	89648	3.7%
Other values (62)	992683	40.7%

None

Value	Count	Frequency (%)
ü	49869	79.1%
ä	6227	9.9%
ö	3514	5.6%
è	1287	2.0%
é	1003	1.6%
â	470	0.7%
Ü	433	0.7%
Ä	54	0.1%
ô	53	0.1%
à	29	< 0.1%
Other values (13)	102	0.2%

ft_startort
Categorical

HIGH CARDINALITY
MISSING

Distinct	6271
Distinct (%)	2.9%
Missing	17653
Missing (%)	7.7%
Memory size	628.2 KiB

Zürich HB	21526
Bern	12069
Basel SBB	8116
Luzern	7366
Zürich Flughafen	6044
Other values (6266)	157662

Length

Max length	31
Median length	27
Mean length	10.29533844
Min length	1

Characters and Unicode

Total characters	2190673
Distinct characters	88
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2882 ?
Unique (%)	1.4%

Sample

1st row	Frauenfeld
2nd row	Rheinfelden
3rd row	Weinfelden
4th row	Visp
5th row	Dottikon-Dintikon

Common Values

Value	Count	Frequency (%)
Zürich HB	21526	9.3%
Bern	12069	5.2%
Basel SBB	8116	3.5%
Luzern	7366	3.2%
Zürich Flughafen	6044	2.6%
Olten	5593	2.4%
Winterthur	4572	2.0%
St. Gallen	3276	1.4%
Chur	2594	1.1%
Zug	2534	1.1%
Other values (6261)	139093	60.4%
(Missing)	17653	7.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
zürich	34075	10.6%
hb	22082	6.9%
bahnhof	20673	6.5%
bern	14117	4.4%
basel	9792	3.1%
sbb	9511	3.0%
luzern	8575	2.7%
flughafen	6481	2.0%
olten	6006	1.9%
winterthur	5836	1.8%
Other values (4864)	183238	57.2%

Most occurring characters

Value	Count	Frequency (%)
e	185475	8.5%
n	182856	8.3%
r	150402	6.9%
h	136880	6.2%
a	128592	5.9%
B	113449	5.2%
i	112656	5.1%
	107627	4.9%
l	94308	4.3%
t	84678	3.9%
Other values (78)	893750	40.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1623837	74.1%
Uppercase Letter	405788	18.5%
Space Separator	107627	4.9%
Other Punctuation	43820	2.0%
Dash Punctuation	7658	0.3%
Open Punctuation	891	< 0.1%
Close Punctuation	891	< 0.1%
Decimal Number	100	< 0.1%
Math Symbol	61	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	185475	11.4%
n	182856	11.3%
r	150402	9.3%
h	136880	8.4%
a	128592	7.9%
i	112656	6.9%
l	94308	5.8%
t	84678	5.2%
o	74731	4.6%
u	73896	4.6%
Other values (28)	399363	24.6%

Uppercase Letter

Value	Count	Frequency (%)
B	113449	28.0%
Z	44714	11.0%
S	43886	10.8%
H	33425	8.2%
L	22281	5.5%
G	19822	4.9%
W	17807	4.4%
A	14102	3.5%
F	14096	3.5%
O	12294	3.0%
Other values (23)	69912	17.2%

Decimal Number

Value	Count	Frequency (%)
4	45	45.0%
6	12	12.0%
3	11	11.0%
1	11	11.0%
7	10	10.0%
2	10	10.0%
0	1	1.0%

Other Punctuation

Value	Count	Frequency (%)
,	30927	70.6%
.	6680	15.2%
/	6158	14.1%
'	31	0.1%
&	24	0.1%

Space Separator

Value	Count	Frequency (%)
	107627	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	7658	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	891	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	891	100.0%

Math Symbol

Value	Count	Frequency (%)
+	61	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2029625	92.6%
Common	161048	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	185475	9.1%
n	182856	9.0%
r	150402	7.4%
h	136880	6.7%
a	128592	6.3%
B	113449	5.6%
i	112656	5.6%
l	94308	4.6%
t	84678	4.2%
o	74731	3.7%
Other values (61)	765598	37.7%

Common

Value	Count	Frequency (%)
	107627	66.8%
,	30927	19.2%
-	7658	4.8%
.	6680	4.1%
/	6158	3.8%
(	891	0.6%
)	891	0.6%
+	61	< 0.1%
4	45	< 0.1%
'	31	< 0.1%
Other values (7)	79	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2138544	97.6%
None	52129	2.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	185475	8.7%
n	182856	8.6%
r	150402	7.0%
h	136880	6.4%
a	128592	6.0%
B	113449	5.3%
i	112656	5.3%
	107627	5.0%
l	94308	4.4%
t	84678	4.0%
Other values (59)	841621	39.4%

None

Value	Count	Frequency (%)
ü	42769	82.0%
ä	4720	9.1%
ö	1525	2.9%
è	1182	2.3%
é	889	1.7%
â	523	1.0%
Ü	368	0.7%
Ä	82	0.2%
Ö	24	< 0.1%
ì	14	< 0.1%
Other values (9)	33	0.1%

ft_zielort
Categorical

HIGH CARDINALITY
MISSING

Distinct	5373
Distinct (%)	2.5%
Missing	17650
Missing (%)	7.7%
Memory size	621.2 KiB

Zürich HB	37226
Bern	18152
Luzern	10680
Olten	8593
Basel SBB	8022
Other values (5368)	130113

Length

Max length	40
Median length	29
Mean length	8.796241294
Min length	3

Characters and Unicode

Total characters	1871717
Distinct characters	85
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2797 ?
Unique (%)	1.3%

Sample

1st row	Oberwinterthur
2nd row	Zürich HB
3rd row	Zürich HB
4th row	Spiez
5th row	Brugg AG

Common Values

Value	Count	Frequency (%)
Zürich HB	37226	16.2%
Bern	18152	7.9%
Luzern	10680	4.6%
Olten	8593	3.7%
Basel SBB	8022	3.5%
Winterthur	5815	2.5%
St. Gallen	4870	2.1%
Zürich Flughafen	4105	1.8%
Chur	3951	1.7%
Aarau	3079	1.3%
Other values (5363)	108293	47.0%
(Missing)	17650	7.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
zürich	50391	16.7%
hb	37767	12.5%
bern	19083	6.3%
luzern	11000	3.7%
olten	8687	2.9%
basel	8457	2.8%
sbb	8215	2.7%
st	6151	2.0%
winterthur	6075	2.0%
gallen	5435	1.8%
Other values (4514)	140036	46.5%

Most occurring characters

Value	Count	Frequency (%)
e	165989	8.9%
r	159031	8.5%
n	142567	7.6%
i	112722	6.0%
B	101066	5.4%
h	96956	5.2%
	88543	4.7%
a	85824	4.6%
l	84307	4.5%
t	72359	3.9%
Other values (75)	762353	40.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1366695	73.0%
Uppercase Letter	392651	21.0%
Space Separator	88543	4.7%
Other Punctuation	15786	0.8%
Dash Punctuation	6385	0.3%
Open Punctuation	763	< 0.1%
Close Punctuation	763	< 0.1%
Decimal Number	127	< 0.1%
Math Symbol	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	165989	12.1%
r	159031	11.6%
n	142567	10.4%
i	112722	8.2%
h	96956	7.1%
a	85824	6.3%
l	84307	6.2%
t	72359	5.3%
c	66773	4.9%
u	64132	4.7%
Other values (27)	316035	23.1%

Uppercase Letter

Value	Count	Frequency (%)
B	101066	25.7%
Z	58776	15.0%
H	44684	11.4%
S	36879	9.4%
L	22130	5.6%
G	18450	4.7%
W	14703	3.7%
O	14649	3.7%
A	13251	3.4%
R	9729	2.5%
Other values (22)	58334	14.9%

Decimal Number

Value	Count	Frequency (%)
4	37	29.1%
7	20	15.7%
6	20	15.7%
3	20	15.7%
2	20	15.7%
1	10	7.9%

Other Punctuation

Value	Count	Frequency (%)
.	6921	43.8%
,	4722	29.9%
/	4121	26.1%
'	20	0.1%
&	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	88543	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6385	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	763	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	763	100.0%

Math Symbol

Value	Count	Frequency (%)
+	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1759346	94.0%
Common	112371	6.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	165989	9.4%
r	159031	9.0%
n	142567	8.1%
i	112722	6.4%
B	101066	5.7%
h	96956	5.5%
a	85824	4.9%
l	84307	4.8%
t	72359	4.1%
c	66773	3.8%
Other values (59)	671752	38.2%

Common

Value	Count	Frequency (%)
	88543	78.8%
.	6921	6.2%
-	6385	5.7%
,	4722	4.2%
/	4121	3.7%
(	763	0.7%
)	763	0.7%
4	37	< 0.1%
'	20	< 0.1%
7	20	< 0.1%
Other values (6)	76	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1807992	96.6%
None	63725	3.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	165989	9.2%
r	159031	8.8%
n	142567	7.9%
i	112722	6.2%
B	101066	5.6%
h	96956	5.4%
	88543	4.9%
a	85824	4.7%
l	84307	4.7%
t	72359	4.0%
Other values (58)	698628	38.6%

None

Value	Count	Frequency (%)
ü	56804	89.1%
ä	3227	5.1%
ö	1019	1.6%
è	932	1.5%
é	693	1.1%
â	525	0.8%
Ü	429	0.7%
Ä	37	0.1%
Ö	19	< 0.1%
ô	9	< 0.1%
Other values (7)	31	< 0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	participant_id	u_date	Kommentar	wime_personal	wime_komfort	wime_sauberkeit	wime_puenktlich	wime_platzangebot	wime_gesamtzuf	wime_preis_leistung	wime_fahrplan	wime_oes_fahrt	S_sprache	S_alter	S_sex	S_wohnsitz	u_klassencode	S_AB3_HTA	R_anschluss	R_stoerung	device_type	dispcode	u_ticket	u_fahrausweis	u_preis	R_zweck	ft_abfahrt	ft_ankunft	ft_startort_uic	ft_tu	ft_vm	ft_vm_kurz	ft_zielort_uic	fg_abfahrt	fg_ankunft	fg_startort_uic	fg_zielort_uic	fg_startort	fg_zielort	ft_startort	ft_zielort
0	642	2019-01-19	None	NaN	88.888889	88.888889	100.000000	100.000000	88.888889	NaN	100.000000	100.000000	Deutsch	NaN	männlich	In der Schweiz / Liechtenstein	2. Klasse	NaN	Ja	Nein	NaN	NaN	NaN	NaN	NaN	Freizeit und Unterhaltung	2022-11-25 17:58:00	2022-11-25 18:10:00	8506100	THU	S 30	S	8506016	2022-11-25 17:58:00	2022-11-25 18:22:00	8506100	8506020	Frauenfeld	Seuzach	Frauenfeld	Oberwinterthur
1	657	2019-03-02	None	100.000000	100.000000	100.000000	100.000000	100.000000	100.000000	NaN	100.000000	100.000000	Deutsch	68.0	männlich	In der Schweiz / Liechtenstein	1. Klasse	NaN	Ja	Nein	NaN	NaN	NaN	NaN	NaN	Freizeit und Unterhaltung	2022-11-25 05:50:00	2022-11-25 06:49:00	8500301	SBB	IR 36 2057	IR	8503000	2022-11-25 05:50:00	2022-11-25 09:18:00	8500301	8505300	Rheinfelden	Lugano	Rheinfelden	Zürich HB
2	24756	2019-04-22	None	NaN	66.666667	66.666667	100.000000	66.666667	77.777778	NaN	100.000000	100.000000	Deutsch	25.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	NaN	Ja	Nein	NaN	NaN	NaN	NaN	NaN	Freizeit und Unterhaltung	2022-11-25 16:36:00	2022-11-25 17:25:00	8506105	SBB	IR 75 2128	IR	8503000	2022-11-25 16:22:00	2022-11-25 18:10:00	8506109	8503207	Amriswil	Richterswil	Weinfelden	Zürich HB
3	25620	2019-01-05	None	88.888889	44.444444	66.666667	100.000000	44.444444	77.777778	NaN	77.777778	88.888889	Deutsch	16.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	NaN	Ja	Nein	NaN	NaN	NaN	NaN	NaN	Freizeit und Unterhaltung	2022-11-25 10:57:00	2022-11-25 11:24:00	8501605	SBB	IC 8 817	IC	8507483	2022-11-25 10:28:00	2022-11-25 11:51:00	8501600	8507493	Salgesch	Interlaken West	Visp	Spiez
4	41215	2019-01-12	None	NaN	88.888889	88.888889	100.000000	100.000000	88.888889	NaN	100.000000	88.888889	Deutsch	72.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	NaN	NaN	Nein	NaN	NaN	NaN	NaN	NaN	Sonstige	2022-11-25 11:10:00	2022-11-25 11:25:00	8502212	SBB	S 25 8540	S	8500309	2022-11-25 11:10:00	2022-11-25 11:25:00	8502212	8500309	Dottikon-Dintikon	Brugg AG	Dottikon-Dintikon	Brugg AG
5	41305	2019-01-04	Habe schon mehrmals erlebt, dass es im Speisewagen keine Gipfeli gab am Morgen. Das war jeweils ärgerlich.	77.777778	44.444444	77.777778	77.777778	77.777778	88.888889	NaN	66.666667	77.777778	Deutsch	24.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	NaN	NaN	Nein	NaN	NaN	NaN	NaN	NaN	Arbeit und Lernen	2022-11-25 16:57:00	2022-11-25 17:25:00	8502206	SBB	IR 75 2663	IR	8505000	2022-11-25 16:57:00	2022-11-25 17:25:00	8502206	8505000	Baar	Luzern	Baar	Luzern
6	41334	2019-02-01	Ansteben, dass auch in gut frequentierte periphere Zentren eine Fahrplanverdichtung erfolgt.Die Trennung von Fernverkehr und Regionalverkehr ist in Frage zu stellen. Schade, dass ich zu meiner ersten Fahrt am Tag Stellung nehmen muss, beginne ich dich mein Reiseprogramm aus Platzgründen im Zug bewusst früher als es nötig wäre...	100.000000	88.888889	100.000000	100.000000	88.888889	88.888889	NaN	100.000000	100.000000	Deutsch	43.0	männlich	In der Schweiz / Liechtenstein	2. Klasse	NaN	NaN	Nein	NaN	NaN	NaN	NaN	NaN	Arbeit und Lernen	2022-11-25 05:50:00	2022-11-25 06:24:00	8507483	SBB	IC 61 1056	IC	8507000	2022-11-25 05:50:00	2022-11-25 06:24:00	8507483	8507000	Spiez	Bern	Spiez	Bern
7	41376	2019-02-24	None	NaN	66.666667	55.555556	100.000000	77.777778	88.888889	NaN	66.666667	77.777778	Deutsch	21.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	NaN	NaN	Nein	NaN	NaN	NaN	NaN	NaN	Arbeit und Lernen	2022-11-25 04:56:00	2022-11-25 05:51:00	8506208	SBB	IR 13 3252	IR	8503000	2022-11-25 04:56:00	2022-11-25 05:51:00	8506208	8503000	Uzwil	Zürich HB	Uzwil	Zürich HB
8	41423	2019-01-06	None	100.000000	100.000000	100.000000	100.000000	100.000000	100.000000	NaN	100.000000	100.000000	Deutsch	35.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	NaN	Ja	Nein	NaN	NaN	NaN	NaN	NaN	Freizeit und Unterhaltung	2022-11-25 17:41:00	2022-11-25 19:28:00	8505213	SBB	IC 2 884	IC	8503000	2022-11-25 17:05:00	2022-11-25 20:58:00	8505400	8507000	Locarno	Bern	Bellinzona	Zürich HB
9	41459	2019-01-07	Die 1. Klasse muss deutluch aufgewertet werden. Die neuen untergeordneten Haltestellen wie Zürich Altstetten und Zürich Oerlikon trüben Fahrerlebnis massiv.	NaN	0.000000	66.666667	55.555556	33.333333	33.333333	NaN	33.333333	100.000000	Deutsch	47.0	männlich	In der Schweiz / Liechtenstein	1. Klasse	NaN	Ja	Nein	NaN	NaN	NaN	NaN	NaN	Arbeit und Lernen	2022-11-25 07:12:00	2022-11-25 08:06:00	8508100	SBB	IR 17 2359	IR	8503000	2022-11-25 07:12:00	2022-11-25 08:38:00	8508100	8506000	Langenthal	Winterthur	Langenthal	Zürich HB

Last rows

	participant_id	u_date	Kommentar	wime_personal	wime_komfort	wime_sauberkeit	wime_puenktlich	wime_platzangebot	wime_gesamtzuf	wime_preis_leistung	wime_fahrplan	wime_oes_fahrt	S_sprache	S_alter	S_sex	S_wohnsitz	u_klassencode	S_AB3_HTA	R_anschluss	R_stoerung	device_type	dispcode	u_ticket	u_fahrausweis	u_preis	R_zweck	ft_abfahrt	ft_ankunft	ft_startort_uic	ft_tu	ft_vm	ft_vm_kurz	ft_zielort_uic	fg_abfahrt	fg_ankunft	fg_startort_uic	fg_zielort_uic	fg_startort	fg_zielort	ft_startort	ft_zielort
230426	589945	2022-11-14	None	100.0	100.0	75.0	100.0	100.0	100.0	75.0	75.0	75.0	Deutsch	75.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	ja	Ja	Nein	Desktop	Beendet	Mobile-Ticket	Normales Billett	18.1	Freizeit und Unterhaltung	2022-11-25 14:58:00	2022-11-25 15:57:00	8506302	SBB	IC-5-528	IC	8503000	2022-11-25 14:31:00	2022-11-25 15:57:00	8506366	8503000	Speicher	Zürich HB	St. Gallen	Zürich HB
230427	589946	2022-11-07	Die WC sind leider häufig sehr sehr schmutzig. Ich fahre diese Strecke öfters.	NaN	NaN	NaN	NaN	NaN	NaN	75.0	100.0	NaN	Deutsch	71.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	ja	NaN	NaN	Desktop	Ausgescreent	NaN	Sparbillett	26.4	Sonstige	NaT	NaT	NaN	NaN	NaN	NaN	NaN	NaT	NaT	NaN	NaN	Liestal	Chur	Liestal	Chur
230428	589951	2022-11-13	None	NaN	75.0	75.0	75.0	25.0	75.0	50.0	75.0	100.0	Deutsch	45.0	männlich	In der Schweiz / Liechtenstein	2. Klasse	ja	Ja	Nein	Desktop	Beendet	Mobile-Ticket	Normales Billett	24.5	Freizeit und Unterhaltung	2022-11-25 18:04:00	2022-11-25 19:13:00	8503000	SBB	IC-5-532	IC	8504300	2022-11-25 18:04:00	2022-11-25 19:23:00	8503000	8576724	Zürich HB	Biel/Bienne, Omega	Zürich HB	Biel/Bienne
230429	589954	2022-11-11	None	100.0	100.0	100.0	100.0	100.0	100.0	100.0	100.0	100.0	Deutsch	49.0	männlich	In der Schweiz / Liechtenstein	2. Klasse	ja	Ja	Nein	Desktop	Beendet	NaN	Sparbillett	22.6	Freizeit und Unterhaltung	2022-11-25 07:02:00	2022-11-25 07:58:00	8507000	SBB	IC-8-807	IC	8503000	2022-11-25 06:39:00	2022-11-25 08:12:00	8504410	8503016	Zollikofen	Zürich Flughafen	Bern	Zürich HB
230430	589955	2022-11-11	None	NaN	75.0	75.0	100.0	100.0	75.0	100.0	100.0	75.0	Deutsch	43.0	männlich	In der Schweiz / Liechtenstein	2. Klasse	ja	Ja	Nein	Desktop	Beendet	NaN	Sparbillett	23.4	Freizeit und Unterhaltung	2022-11-25 12:31:00	2022-11-25 13:28:00	8507000	SBB	IC-1-717	IC	8503000	2022-11-25 11:40:00	2022-11-25 13:28:00	8504194	8503000	Laupen BE	Zürich HB	Bern	Zürich HB
230431	589956	2022-11-13	None	0.0	NaN	NaN	100.0	100.0	25.0	50.0	0.0	100.0	Deutsch	NaN	divers	In der Schweiz / Liechtenstein	2. Klasse	nein	Ja	Nein	Desktop	Beendet	NaN	Sparbillett	20.2	Freizeit und Unterhaltung	2022-11-25 15:42:00	2022-11-25 16:24:00	8500305	SBB	IR-36-1977	IR	8503000	2022-11-25 15:42:00	2022-11-25 16:43:00	8500305	8591183	Frick	Zürich, Helmhaus	Frick	Zürich HB
230432	589957	2022-11-13	None	NaN	100.0	100.0	75.0	75.0	100.0	75.0	100.0	100.0	Deutsch	48.0	weiblich	In der Schweiz / Liechtenstein	1. Klasse	ja	Ja	Nein	Desktop	Beendet	Mobile-Ticket	Normales Billett	57.0	Freizeit und Unterhaltung	2022-11-25 15:34:00	2022-11-25 16:58:00	8507100	SBB	IC-8-825	IC	8503000	2022-11-25 15:34:00	2022-11-25 17:22:00	8507100	8503400	Thun	Bülach	Thun	Zürich HB
230433	589959	2022-11-11	Ich hatte meinen grossen Hund (Deutsche Dogge) dabei und war sehr zufrieden mit unserem Platz im Spielwagon unten, freie Fläche zum liegen für den Hund und dennoch eine Sitzgelegenheit für mich. Der Zugbegleiter war grandios.	100.0	100.0	75.0	100.0	100.0	100.0	75.0	100.0	100.0	Deutsch	38.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	nein	Ja	Nein	Desktop	Beendet	NaN	Sparbillett	34.2	Freizeit und Unterhaltung	2022-11-25 09:36:00	2022-11-25 10:32:00	8507000	SBB	IC-61-1062	IC	8500010	2022-11-25 09:04:00	2022-11-25 10:56:00	8504105	8578157	Niederwangen	Basel, Neuweilerstrasse	Bern	Basel SBB
230434	589962	2022-11-13	Die nahtlosen Anschlüsse habe ich sehr geschätzt, sodass ich rasch von Basel nach Hause kam. Sicherheitspersonal oder Kondukteure im Zug erhöhen das Sicherheitsgefühl positiv. Die Züge donnerstags abends um 22.36 Uhr sind stets überfüllt! Bitte mehr Wagen anhängen. Die Reinigung der Züge ist unterschiedlich - die Fahrgäste und ihr Verhalten wohl leider auch.	NaN	75.0	50.0	100.0	100.0	75.0	75.0	100.0	75.0	Deutsch	61.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	ja	Ja	Nein	Desktop	Beendet	Mobile-Ticket	Normales Billett	12.9	Freizeit und Unterhaltung	2022-11-25 17:11:00	2022-11-25 17:57:00	8500010	SBB	IR-36-1981	IR	8500309	2022-11-25 17:11:00	2022-11-25 18:12:00	8500010	8503777	Basel SBB	Untersiggenthal, Spiracher	Basel SBB	Brugg AG
230435	589965	2022-11-12	None	100.0	75.0	100.0	100.0	100.0	100.0	100.0	100.0	100.0	Deutsch	64.0	weiblich	In der Schweiz / Liechtenstein	2. Klasse	ja	Ja	Nein	Desktop	Beendet	NaN	Sparbillett	27.4	Freizeit und Unterhaltung	2022-11-25 09:29:00	2022-11-25 11:22:00	8502204	SBB	IR-70-2616	IR	8506302	2022-11-25 07:59:00	2022-11-25 11:22:00	8508211	8506302	Schüpfheim	St. Gallen	Zug	St. Gallen

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Open Punctuation

Modifier Symbol

Dash Punctuation

Close Punctuation

Initial Punctuation

Final Punctuation

Space Separator

Currency Symbol

Other Number

Other Symbol

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Currency Symbols

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length